G
Gareth
I have a sheet with column headings in A1 to N1
Data from a text file is then pasted into A2 (can be up to 1000 rows).
I want to then delete some of this data and move the remainder around so
that users can carry out ceratin calculations.
After pasting the sheet has data in the range A2:K? What I would like to do
next is run a macro which would do the following:
1. Delete contents of A, B, G, J and K
2. Move contents of column F into column A
3. Have the letter 'M' put into all cells in column B
4. Insert 3 columns to the right of column B
5. Delete empty columns I and J
I have recorded this and have a very crude working macro, hope someone can
help.
Gareth
Data from a text file is then pasted into A2 (can be up to 1000 rows).
I want to then delete some of this data and move the remainder around so
that users can carry out ceratin calculations.
After pasting the sheet has data in the range A2:K? What I would like to do
next is run a macro which would do the following:
1. Delete contents of A, B, G, J and K
2. Move contents of column F into column A
3. Have the letter 'M' put into all cells in column B
4. Insert 3 columns to the right of column B
5. Delete empty columns I and J
I have recorded this and have a very crude working macro, hope someone can
help.
Gareth