jonnysamuel12
New Member
- Joined
- Jun 20, 2018
- Messages
- 1
Hi,
I have 3 tables in 3 different worksheets. I want to setup a Macro to copy and paste the data from all 3 tables into another workbook (pre-existing), pasting one below the other and keeping the set of headings from the first table.
The headings of the 3 tables are all identical.
The number of rows in the table will change every time I use this Macro as data is constantly being added to these 3 tables.
So let's assume:
Sheet1
Table range:
- columns A:C
- rows: currently 1-5, but could be longer
Sheet2
Table range:
- columns A:C
- rows: currently 1-5, but could be longer
Sheet3
Table range:
- columns A:C
- rows: currently 1-5, but could be longer
I'm new to Mr Excel so forgive me if I've written anything incorrectly.
Really appreciate anyone who can help.
Happy to answer any more questions if need be.
Kind regards,
Jonny
I have 3 tables in 3 different worksheets. I want to setup a Macro to copy and paste the data from all 3 tables into another workbook (pre-existing), pasting one below the other and keeping the set of headings from the first table.
The headings of the 3 tables are all identical.
The number of rows in the table will change every time I use this Macro as data is constantly being added to these 3 tables.
So let's assume:
Sheet1
Table range:
- columns A:C
- rows: currently 1-5, but could be longer
Sheet2
Table range:
- columns A:C
- rows: currently 1-5, but could be longer
Sheet3
Table range:
- columns A:C
- rows: currently 1-5, but could be longer
I'm new to Mr Excel so forgive me if I've written anything incorrectly.
Really appreciate anyone who can help.
Happy to answer any more questions if need be.
Kind regards,
Jonny