Hello,
My name is Niclas.
I would really need some assistant on which approach to take for the bellow topic.
What I would like to achieve is the following:
- I have several workbooks containing one sheet, with a lot of specialized formatting with a lot of different information.
- What I would like to do is, to copy all the information together with the formatting from all the different workbooks and sheets. Combine the information into one "Master" workbook, containing one sheet with all the information pasted from the other workbooks and sheets.
MEANING:
- The rows that contains the information needs to be copied to the "master" workbook into the sheet under the same "category" as in column A
- This has to be done from several different workbooks and sheets "approx. 6 different."
- I never know how many rows that will actually contain information under each category. So the macro or other approach needs to take into consideration the following:
- When coping the information from the separate workbooks and sheets. "Howto" determine how many rows to copy and howto paste them into the correct category in the master file without overwriting any other text etc..
I want this to be done in a automatic way with a button press or by executing a macro.
It works like this:
- I have several different persons creating all these different workbooks containing one sheet.
- When the deadline is due, I want to summarize all information into one "master file" in a atomized way.
I have a office 365 subscription so my Excel is updated accordingly. It runs on a windows 10 machine.
Hope this makes sense.
Br Niclas
My name is Niclas.
I would really need some assistant on which approach to take for the bellow topic.
What I would like to achieve is the following:
- I have several workbooks containing one sheet, with a lot of specialized formatting with a lot of different information.
- What I would like to do is, to copy all the information together with the formatting from all the different workbooks and sheets. Combine the information into one "Master" workbook, containing one sheet with all the information pasted from the other workbooks and sheets.
MEANING:
- The rows that contains the information needs to be copied to the "master" workbook into the sheet under the same "category" as in column A
- This has to be done from several different workbooks and sheets "approx. 6 different."
- I never know how many rows that will actually contain information under each category. So the macro or other approach needs to take into consideration the following:
- When coping the information from the separate workbooks and sheets. "Howto" determine how many rows to copy and howto paste them into the correct category in the master file without overwriting any other text etc..
I want this to be done in a automatic way with a button press or by executing a macro.
It works like this:
- I have several different persons creating all these different workbooks containing one sheet.
- When the deadline is due, I want to summarize all information into one "master file" in a atomized way.
I have a office 365 subscription so my Excel is updated accordingly. It runs on a windows 10 machine.
Hope this makes sense.
Br Niclas