garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Hi, I do not think I can post a file on here.
Basically what I am looing for is a VBA script to do the following.
I have say 8 sheets which data will always be changing (adding / removing) and 1 sheet which is say called combined. The headings are the same on all sheets.
What I would like the VBA script to do is:
1. take all the information from row 2 onward (row 1 is headings and not needed) but it go to the LR (last row) of data on all sheets (except combined)
2. I would like it to paste the information of all sheets into the combined tab. There should be a offset on 1 with each sheet to separate by 1 line between each sheet.
Is there a simple way of doing this? I can record the macro, and play with the script myself. But I know the Script will not be a simple as it likely should be as there seems always to be a much simple and advance way of doing something.
Any help would be great.
Basically what I am looing for is a VBA script to do the following.
I have say 8 sheets which data will always be changing (adding / removing) and 1 sheet which is say called combined. The headings are the same on all sheets.
What I would like the VBA script to do is:
1. take all the information from row 2 onward (row 1 is headings and not needed) but it go to the LR (last row) of data on all sheets (except combined)
2. I would like it to paste the information of all sheets into the combined tab. There should be a offset on 1 with each sheet to separate by 1 line between each sheet.
Is there a simple way of doing this? I can record the macro, and play with the script myself. But I know the Script will not be a simple as it likely should be as there seems always to be a much simple and advance way of doing something.
Any help would be great.