Graham Cobden
New Member
Hi All,
I have been trying to create a macro in order to automate moving data from one workbook 'input worksheet' to another workbook 'master workbook'. Both sheets are in the same file and if possible, it would be great if both files didn't have to be open at the same time in order to transfer the data but the master workbook would autosave once the data was transferred across.
The data in the input worksheet is in row 6, columns A-J with each user inputting details of the tasks they get asked to complete. What I would like is when a button is clicked, the data from the input worksheet is transferred into row 2, columns B-K in the master workbook so that each time a new task is entered and transferred across, it appears in the row below (so that it can be pivoted later, etc).
I have attached example workbooks to give an idea of potential layout.
Any help that can be offered would be greatly appreciated.
Many thanks,
Graham
I have been trying to create a macro in order to automate moving data from one workbook 'input worksheet' to another workbook 'master workbook'. Both sheets are in the same file and if possible, it would be great if both files didn't have to be open at the same time in order to transfer the data but the master workbook would autosave once the data was transferred across.
The data in the input worksheet is in row 6, columns A-J with each user inputting details of the tasks they get asked to complete. What I would like is when a button is clicked, the data from the input worksheet is transferred into row 2, columns B-K in the master workbook so that each time a new task is entered and transferred across, it appears in the row below (so that it can be pivoted later, etc).
I have attached example workbooks to give an idea of potential layout.
Any help that can be offered would be greatly appreciated.
Many thanks,
Graham