Hi, I am trying to create a macro, which will go through specified sheets in my workbook and then copy entire rows to new sheet, if values in column P in each of those sheets are not blank. Any ideas how can I approach that? Many thanks.
Hi, I am trying to create a macro, which will go through specified sheets in my workbook and then copy entire rows to new sheet, if values in column P in each of those sheets are not blank. Any ideas how can I approach that? Many thanks.
Hi bizzarofen
This has been tested and works...
Please Login or Register to view this content.
Last edited by sintek; 04-27-2017 at 09:13 AM. Reason: Changed code to tested code
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thank you very much Sintek, that's basically what I've been trying to build. Is there just a way to copy entire rows as values?
Change this
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 04-27-2017 at 09:15 AM.
I am getting a run time error, that:" Select method of Range class failed ", when I change this line
Thank you so much sintek, it works just flawlessly now.
Glad I could help...Please mark thread as solved and add to Reputation....[Click on star and ADD REPUTATION]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks