Hey
I'm trying to create macro which goes to the last column that has data in it, copying it to the one after that.
eg: I have a couple of values in column C. I want to copy this, by using a macro, to column D. Then, the next time I run the macro I want it to copy the values in column D to column E... and so on.
I know my explanation is bad, but I hope you'll understand.
Cheers
Fro
I'm trying to create macro which goes to the last column that has data in it, copying it to the one after that.
eg: I have a couple of values in column C. I want to copy this, by using a macro, to column D. Then, the next time I run the macro I want it to copy the values in column D to column E... and so on.
I know my explanation is bad, but I hope you'll understand.
Cheers
Fro