G
George K
Is it possible to write a macro that cuts the active cell and the cell next
to it and paste them under the last entry of the two columns to its left?
COLUMN A COL B COL C COL D COL E COL F
this 5 new 2
pen 10
that 10 newer 4
pencil 15
the other 2 newest 10
ruler 8
blah 4 low 20
high 10
In the above example, could you put the cursor on Pencil (E2) and make a
macro to cut both it (E2) and next one (F2), and paste them under "high",
"10". i.e. Under the last entry of the two columns to the left?
Also, could it also sort Columns C and D, by Column C?
Thanks,
George
to it and paste them under the last entry of the two columns to its left?
COLUMN A COL B COL C COL D COL E COL F
this 5 new 2
pen 10
that 10 newer 4
pencil 15
the other 2 newest 10
ruler 8
blah 4 low 20
high 10
In the above example, could you put the cursor on Pencil (E2) and make a
macro to cut both it (E2) and next one (F2), and paste them under "high",
"10". i.e. Under the last entry of the two columns to the left?
Also, could it also sort Columns C and D, by Column C?
Thanks,
George