Copy column for cell reference to an existing sheet, with matching sheet name as cell

Can someonwe please help. I have been trying to sort this out for 2 days

I have a sheet called Sheet2 that contains many column with data in rows 1 to 29. In row 4 of each column there is a number eg 1234, in the same workbook there are empty sheets with the same references as in row 4, hence many empty sheets.
I want to copy from sheet2 the information from row one to row 29 in a new column on the empty sheets that have the same number in row 4. There may be several records in sheet two with the same reference in row 4, so these have to be copied to the correct sheet. If the destination sheets already have information in them , then the new data must be copied to the next empty column.

I have been trying to go sheet2, goes to the first colum, checks to see what reference is in row 4, then copies it to the relevant next empty column in the appropriate sheet. Then return to sheet 2, go to the next column and start over again, until in sheet 2 row 4 is empty, then stop the program

I have tried, had a bit of success, but always fail in one way or another

Hi there,

I just might be able to help you out with this one.

A question - what is the criterion for determining that all data on Sheet 2 have been processed? Is it encountering an empty column on Sheet 2, or is it encountering a non-empty column which has no value (worksheet name) in Row 4?

Regards,

Greg M

Maybe:

Please Login or Register  to view this content.