Hi all
I am in need of a macro that can copy, edit and paste data from one sheet to another.
Here are the details:
Sheet 1 contains data in column 1 (variuos numbers of rows e.g. from A1:A3 or A1:A12).
The text in A1 should then be copied to sheet 2 to field A1 and have the letter "A" added to the text.
Again the data from A1 should be copied to sheet 2 to field A2 and have the letter "B" added to the text.
The text in field A2 (sheet 1) should be copied to sheet 2 field A3 with the letter "A" after and to field A4 with the letter "B" after.
and so on...
Once the macro encounters a blank field in sheet 1 it should stop.
Could anyone please help?
Bookmarks