My spreadsheet has a header record, then 3 rows per record set,
with 7 columns per row.
The first 4 columns are constant within each group of 3.
I would like to append cell E3 (text) to H2, and then cell F4 ( a date) to I2,
giving the 1st row 9 columns.
I then wish to delete the 2nd and 3rd row of each set.
I can do all this manually, by concatenating, copying and pasting special (values),
and then sorting to identify and delete the necessary rows,
but would obviously rather automate the task.
I have never written a macro before, and suspect I need one to accomplish my task.
Can anyone advise this novice how to go about this ?
Many thanks
Bookmarks