freddie mitchell
New Member
- Joined
- Apr 14, 2011
- Messages
- 43
Hi everyone,
Simple question. Is there a way of Macro copying data from one workbook to another without deleting existing data in the latter workbook?
I recognise one workaround would be an insert / add row function, but not sure if there is a concatenating function that I could use? For example I'd like to copy data from Workbook Z, cell B:3 to Workbook Y, cell B:3, without deleting any existing data in Workbook Y, cell B:3?
The context is that I'm building a development tracker, in which multiple people will update a master workbook with their data, but this data could be added to the same cells by multiple people. And so I'd like to avoid data being overwritten each time.
Thank you for all your invaluable help.
Simple question. Is there a way of Macro copying data from one workbook to another without deleting existing data in the latter workbook?
I recognise one workaround would be an insert / add row function, but not sure if there is a concatenating function that I could use? For example I'd like to copy data from Workbook Z, cell B:3 to Workbook Y, cell B:3, without deleting any existing data in Workbook Y, cell B:3?
The context is that I'm building a development tracker, in which multiple people will update a master workbook with their data, but this data could be added to the same cells by multiple people. And so I'd like to avoid data being overwritten each time.
Thank you for all your invaluable help.