Copy Data from one sheet and putting it below a particular Cell [Closed]

Report
Posts
2
Registration date
Wednesday February 12, 2014
Status
Member
Last seen
September 12, 2014
-
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
-
I have a excel with 3 sheets .
My requirement is to pull data from sheet1 ,sheet2 and put it into sheet3.

There would be two headings in sheet 3 1)Active which would pull records from sheet1 and put it under it.
2) Inactive which would pull records from sheet2 and place it under Inactive cell

First it would populate from sheet1 to sheet3 under Active cell and then it should pull data from sheet2 and put in under inactive cell.


Please advise as I am new to VBA.

Thanks

1 reply

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Sorry Ajita, not seeing the problem here. What is wrong with copy/paste?

Best regards,
Trowa