Hi all. I have 2 sheets; Master and Result. I want to run a code that if row n, col C of Master satisfies some condition, I will copy the whole row and paste into the last row of the Result sheet. Both sheet have header, same order header. So when it paste into Result sheet, it will start with row 2, then row 3, etc...which way is the best way to paste into the last row + 1 (because the last row already contains data) of sheet Result?
Thank guys
Hi
Post sample data...
Click *, if my suggestion helps you. Have a good day!!
It's really hard to fully understand without a sample workbook. With that said, the following is untested, but should at the very least get you going in the right direction.
Please make a copy of your workbook and test the code on your copy.
Please Login or Register to view this content.
Last edited by AlvaroSiza; 04-18-2012 at 12:15 PM.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks