jaykim215
02-09-2017, 08:32 PM
Hello. I apologize if this request is too long, but I need to learn a way where I can consolidate the same worksheet from different workbooks into one; therefore, creating a master budget. The catch: the workbooks are in the same folder, but may be mapped differently on the server depending on the person (i.e. the folder for me is in S: drive while another person it is in the L: drive).
Some key notes:
1. I want to copy all data from columns A:U, but starting on row 6.
2. Information is constantly added to these rows under the A:U columns. (I want the master budget to be able to constantly update if the other worksheets are updated)
-The worksheet name in each workbook is named 'Master Budget'
-The workbook names are 'FY2017 CPP Name.xlsm'
Is there any way to accomplish this using VBA? I've been trying to combine different codes online, but most of them work for consolidating multiple worksheets in only one workbook. Please let me know if you need any more information and I appreciate the help!
Warmly,
Jay
Some key notes:
1. I want to copy all data from columns A:U, but starting on row 6.
2. Information is constantly added to these rows under the A:U columns. (I want the master budget to be able to constantly update if the other worksheets are updated)
-The worksheet name in each workbook is named 'Master Budget'
-The workbook names are 'FY2017 CPP Name.xlsm'
Is there any way to accomplish this using VBA? I've been trying to combine different codes online, but most of them work for consolidating multiple worksheets in only one workbook. Please let me know if you need any more information and I appreciate the help!
Warmly,
Jay