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

Closed
ajita Posts 1 Registration date Wednesday February 12, 2014 Status Member Last seen September 12, 2014 - Feb 12, 2014 at 02:52 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 17, 2014 at 11:08 AM
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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 17, 2014 at 11:08 AM
Sorry Ajita, not seeing the problem here. What is wrong with copy/paste?

Best regards,
Trowa
0