MACRO for CUT & PASTE from cell X to Y

Dear all,

I'm new to VBA macros.

I am trying to write a macro for CUT & PASTE from one column to another.
The data is always in cell 'I', and should be transfered to cell 'F' (CUT & PASTE).
However, not all the cells in column 'I' are populated, therefore it is required to skip the empty cells.

I've attached a small example of the data.

Can anyone please help?

Thanks in advance!
ng

ngilon,
I am always wondered why are some excel spread sheets appear weird. Your columns are upside down.

Please Login or Register  to view this content.