Good evening everyone,
I have spent multiple hours trying to work out a problem that seems like it should be very easy but I just can't get to work, after dozens and dozens of failed attempts I found a code posted via googling that mostly works. I have a workbook with several tabs I want it to create a new tab and then copy content onto that new tab from another tab (i.e. the old tab) based on specifc values in column A of that old page ( I have a list of ~15 things I am loooking for in column A but reduced example). My issue is that the code runs perfect right until the end of the last line than before it can change to "end sub" it gives me a " Run-time error ‘1004’
Application-defined or object-defined error" and it adds an unasked for worksheet to the workbook with an ever increasing number and errors out ?? Thanks so very much for any and all help, it's greatly appreciated!! Lili
I also got this to mostly work but only would work with searching for one value in column a but it was ALSO erroring out at the end and trying to a add an additional worksheet.
Bookmarks