Hi All,
I know that the title sounds a bit complicated, so here's the codes so far.
I've used macro recorder to achieve this.
Sub Macro1()
From here, all of you can see that the steps are repetitive. Sheet "EGT ID" contains a long column of values and you can see it in the range C3, C4, C5 and the list goes on. Its a total of 500 values.
Sheet "Sheet1 (2)", "Sheet1 (3)", "Sheet1 (4)" and so on are the the destinations of where the different cells from sheet "EGT ID" should go to.
This macro recorded works perfectly fine, but just one small issue: there's 500 sheets that i need to copy to ("Sheet1" to "Sheet1 (500)".
Basically, there is 500 values/cells (C2 to C501) in sheet "EGT ID" to be inserted individually in the 500 sheets ("Sheet1" to "Sheet1 (500)") in cell B2 of each sheet.
So is there a way to automate/fine-tune the codes above for it to work?
Many thanks in advance to any VBA experts and gurus out there who are willing to help
Bookmarks