Hi, I've been searching the web and could not find what I specifically need. I hope someone would be able to help.
I have attached a sample sheet.
What I want:
1. The information in sheet (Main) must be copied to a new sheet, then the new sheet should be renamed to whatever is in cell A1:C1 (In any given month there could be between 5 - 15 new sheets that will be created)
2. Copy from Main sheet cell A2:C2 and paste in new sheet at cell A1:C1
3. Copy from Main sheet cell A10:C* (* means that every month the information differ, thus one month it could be two rows, where other months it could be as long as 1000 rows), paste in new sheet at cell A5:C*
4. After information in the new sheet is pasted, the new sheet name should be renamed to the information in A1:C1
I hope this make sense.
Bookmarks