Hi Mr.excelsiors,
I have 3 workbooks with the same table that users need to fill with their own information. I would like to centralize all answers in a different workbook (master workbook) that already exists.
So the idea is as follows: User 1 opens "workbook_user1" and fills the information. Once he is done, he presses the macro button and sends the information which is copied into the "master_workbook". User 2 opens "workbook_user2" and doest exactly the same and the information is sent to the master workbook and pasted below user1 information. Each time the copy&paste is done, it should save the master workbook without prompting.
I have been struggling how to approach this problem as it should not be difficult to solve. At the beginning I tried saving the information in a different sheet in each workbook and using the option "consolidate" in the masterbook, trying to put all the information together, but it did not work.
After that, I tried to use a macro to send the information from the users workbook into the masters workbook, by copying some people ideas to a different problem, but I ended up with a Frankenstein macro that does not work as it should.
Can you give me a helpful hand?
I have 3 workbooks with the same table that users need to fill with their own information. I would like to centralize all answers in a different workbook (master workbook) that already exists.
So the idea is as follows: User 1 opens "workbook_user1" and fills the information. Once he is done, he presses the macro button and sends the information which is copied into the "master_workbook". User 2 opens "workbook_user2" and doest exactly the same and the information is sent to the master workbook and pasted below user1 information. Each time the copy&paste is done, it should save the master workbook without prompting.
I have been struggling how to approach this problem as it should not be difficult to solve. At the beginning I tried saving the information in a different sheet in each workbook and using the option "consolidate" in the masterbook, trying to put all the information together, but it did not work.
After that, I tried to use a macro to send the information from the users workbook into the masters workbook, by copying some people ideas to a different problem, but I ended up with a Frankenstein macro that does not work as it should.
Can you give me a helpful hand?

Last edited: