Hey guys,
I was wondering if someone could help me out with a macro that involves copying and pasting entire rows from 1 sheet to a new sheet. The only rows I want however are the ones that are highlighted (.Interior.ColorIndex = 6).
Please help. I appreciate the time and effort.
Last edited by TShelt; 12-16-2011 at 12:31 PM. Reason: Steffen solved.
Try this
Please Login or Register to view this content.
Last edited by Steffen Thomsen; 12-16-2011 at 12:18 PM. Reason: Updated code
Hi Steffen, thanks for replying - I am testing that out now. Some more info is this -
The sheet that i will be copying the rows from is named "ResCap"
The sheet I want to copy the rows to is called "YesMatch"
Thanks again. Will get back to you ASAP
Updated code above!
Getting an error with this. Hopefully the info above helps a little more. The rows are also not going to be consecutive. Meaning it could be rows 3, 5, 10, and 18...it will differ. Not sure if that matters.
Beautiful. Working great - could you help me add one more thing - I always want Row 1 to be copied over there, preferably first.
Got it - Thanks! Closing out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks