I’m after some assistance creating the correct VBA to do the following:
-I have 14 workbooks all contained within the same folder.
-The folders path will be “C:\Users\cowen\Documents\Yield Tracker V2”
-Within these workbooks is a data entry sheet which is sheet fall but named, “DBEntry”
-The layout of these sheets and the headers are exactly the same for all 14 sites which each have 1 workbook.
I want to be able to copy across the data from the DB entry sheet, this will always be between column B and s however depending on the amount of data entered it may be 20 rows or it may be 200 rows. Once copied I was the information deposited into an Workbook called Yield Tracker V2 Master and within that sheet DB Entry.
I would like all the data to merge rather than each workbook over-right the previous one.
Any help is greatly appreciated Colin