Macro to move selected cell contents to a specific column on same row
Hello,
I am trying to write a macro to move data from one cell to a specific
column on the same row.
I have a data table like this:
A B C D E F
1 EMPLID Name Recommended Reserve Hover Not_Competetive
2 8163249 Bloggs
3 8894890 Jones
4 8293943 Smith
The order of names is important, and the EMPID needs to stay in column
A while the name needs to be able to be moved between columns
C,D,E,etc when you press an appropriate toolbar button.
eg.
A B C D E F
1 EMPLID Name Recommended Reserve Hover Not_Competetive
2 8163249 Bloggs
3 8894890 Jones
4 8293943 Smith
I need the flexibility of later on saying, "now I want Smith to move
to the Reserve column". I thought I could use the offset function to
select column A + 3 and past the data in there but I couldnt work out
how to make the offset always reference column A
Thanks,
Ben
|