PDA

View Full Version : Merge data from multiple spreadsheets into one master sheet.



Seacowdaz
06-18-2018, 03:47 AM
Hi,

I’m after some assistance creating the correct VBA to do the following:



There will be several workbooks stored in the same location (with different filenames but they should start with ‘Chase updates’) C:\Users\SmithJ\Documents\Spreadsheets
In these workbooks is a sheet called. ‘Chases’ all workbooks in the folder and the master sheet have the same format.
I want to copy the data from the chase spreadsheets the data I want to copy will start in Cell B14 and got across to cell I14 but the amount of rows of data will vary from sheet to sheet.
Once copied I want the data entered into the master spreadsheet ’Chase updates for WC’ on the ‘Totals’ sheet. Again the data would be pasted into the same location as it was pasted from B14 toI14 down, the data would need to merge all the data from the spreadsheets into this master sheet rather than copying over the data each time.



I know there are similar solutions on the internet but I have not been abel to modify them to suit what I require.

i have also included examples of both sheets attached


2244522444