Hi all,
I am attempting to run a process that will populate worksheets in a workbook from a summary sheet.
The summary sheet contains a table that has a prefix of "X" followed by numbers 1 to 20, which correspond to the naming convention of the worksheets in the workbook. What I am looking to do is match up the data from the summary sheet and populate a range of cells in the corresponding worksheet (e.g. if in the table "X17" has a number 26 beside it, I would like that number to be entered in cell "D2" in the spreadsheet named "X17").
I have attempted this a few different ways including:
Dim I As Long
For I = Sheets("X1") To ("X20")
If Worksheets = I Then ...
However, this errors. Although I've used VBA for a while now it has only been for very limited things and I've never worked with arrays or do loops.
I would be really grateful for any help or advice on how to proceed with this.
Thank you
Bookmarks