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

Closed
ajita Posts 1 Registration date Wednesday 12 February 2014 Status Member Last seen 12 September 2014 - 12 Feb 2014 à 14:52
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 17 Feb 2014 à 11:08
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 response

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

Best regards,
Trowa