Merge data from multiple spreadsheets into one master sheet.

Gimmers

New member
Joined
Jun 18, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2013, 2016
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


View attachment Chase updates for WC.xlsmView attachment Chase Updates.xlsx
 
This question has been cross posted to other forums.
You know the rules since you were directed here to read the 'Message to forum cross posters' here, by the moderator Fluff at MrExcel: https://www.mrexcel.com/forum/excel...form-editor-name-post5062889.html#post5062889 only a few weeks ago.
Supply the links to all your cross posts (you will have to miss off the https:// or www. part because as a new member here you won't be able to post working links until you have 5 messages to your name) then people willing to help you will be able to check on your progress on this question elsewhere and thus provide meaningful suggestions.
 
Last edited:
Back
Top