zeekmcphee
New Member
- Joined
- Feb 27, 2018
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
Hello,
I have 6 sheets(sheets 1 to 6) full of data.The data rows will vary in length from a few rows to several hundred.Once the data has been collected in these sheets I copy and paste them all into one sheet,(sheet7)with the data from sheet one at the top,the data from sheet two directly underneath and so on.
I tried using a macro but of course the varying lengths of each sheet means that an ordinary macro wont work because data will be overidden,or their could be a gap in the data.
Is there a way to get automate this without copy and pasting,perhaps by using some vba code.
Ragards
Zeek
I have 6 sheets(sheets 1 to 6) full of data.The data rows will vary in length from a few rows to several hundred.Once the data has been collected in these sheets I copy and paste them all into one sheet,(sheet7)with the data from sheet one at the top,the data from sheet two directly underneath and so on.
I tried using a macro but of course the varying lengths of each sheet means that an ordinary macro wont work because data will be overidden,or their could be a gap in the data.
Is there a way to get automate this without copy and pasting,perhaps by using some vba code.
Ragards
Zeek