Hey There
I have the below code which is supposed to copy over only a specific row that matches certain criteria to another sheet...Can't get it to work....
I have attached a sample file. Would appreciate some insight....
Please Login or Register to view this content.
1. If you're deleting rows as you go, you need to start at the bottom and loop up. TR to 1 Step -1.
2. i is the variable being incremented, not TR.
3. 2 should be replaced by the variable i
4. You need to reset HR within the loop, not just before you start.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi TMS
thank you for your valuable input. I found and tweaked this code which works...Only problem is, i can't get the first row of the Table to be populated. Always populates below that row.
Please Login or Register to view this content.
Nope, not working...No loop available.
This is sooooo confusing
K, so this works. Less confusing than my original code.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks