Inventory Main sheet has products in Col A, suppliers in col N. When MAKEPO sub is run I want to make new sheets named by data in Col N (supplier name) and populate with data from current row in main sheet. If sheet already exists, add the data to it. Problem is if the sheet already exists, I get error 1004.
0 Answers
Related