Hello,
I was hoping that someone could help me with figuring out how to write the following code:
I currently have a master tab that populates a sheet name in cell C5 based on inputs that are found within that sheet. That value in C5 is the name of one of the sheets found in the file. This value can be one of 80 different values, so there are 80 different sheets; one for each value. I need the macro to essentially see the value found in C5 and then copy data in cells B9:E9 and paste it into the worksheet that matches cell C5, starting on cell B9.
If the macro sees a value already in cell B9, then it would go down to the next blank row (B10 in this case or if B10 had data, then B11, etc.) and paste it there.
I have been trying to look throughout the forum to see if anybody else has asked this, but no luck. Any help would be greatly appreciated!
Thanks,
Chris
Bookmarks