I have many sheets generated and named from cell values in a column (Q10) on sheet1, the sheet name takes the form 000-12345ABC and each sheet increments by 5 each time so the next sheet would be 005-12345ABC, then 010-12345ABC and so on.
I then want to copy a column of text into each of the sheets and change a few of the values in this column to match certain values in my main sheet. Writing it out longhand I suppose this is what I want:
If the sheet name starts with 000(or 005, 010 ect) then look in sheet1, find the value 000(or 005, 010 ect) in column N and insert the value from column P from the same row.
Any Ideas?
Tim
Bookmarks