Thanks to this forum I've got some good code working - I need to make a change to it which will make a big difference to my project


What this code does is as follows:

1) for each name in Column A (with each line in the spreadsheet being an individual entry for a named client) create a new worksheet, named with the value of the cell in that column. E.g Henry, Thomas, Christa in rows 2, 3, 4 creates 3 worksheets entitled 'Henry', 'Thomas' and 'Christa'.

The specific function is actually to make a copy of an existing sheet and rename it to the name of the relevant person, instead of a whole new worksheet. This is because each sheet needs to be in a set format rather than starting from a blank.

The next bit of code fills in the sheet with values in each line of entry. E.g, Cells(7, 4).Value = Worksheets("DataDump").Cells(2, 3).Value means that the value of row 7 column 4 in the spreadsheet entry will be sent into row 2 column 3 of the worksheet.

But ideally, each worksheet needs to be completed with the entries from the relevant line - and not all from the same line. Therefore my reference to specific rows is currently not working because it is filling all sheets the values from row 1.

Instead, each line should correspond to its own sheet.

Any ideas?


Please Login or Register  to view this content.