Hi I have a work book with a lot of sheets.
I'm trying to copy only the rows in each sheet with the below criteria into "Sheet1" with the name of the sheet
So sheet 2 would copy into Sheet on starting at A1 = Sheet name; A2 = "%SET Pkg_Path% A3 = "%SET Pkg_Nm%
then repeat for Sheet 3 starting on A4
I know the looping numbers are off and not sure of another way to do this.
Please advise!
Please Login or Register to view this content.
Last edited by k2hunter; 04-10-2019 at 01:09 PM.
As long as you don't have more than one occurrence of each cirteria on the same row, this should work for you.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
After running the code it appears that nothing is being transferred to the first sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks