Help Excel Macro to move rows

Closed
Report
-
 Noelski -
Hello Everyone,

May i ask your assistance in a macro to move the cell to the right if the contents are not numbers.

i currently have a data list but column C, D and E are not aligned, if there was a macro that would move it would do the trick.

Kind regards,

Noelski

2 replies


Hye Noelski,, Normally this is automatically done if you have set the cell format to general, text are aligned to left and number to the right ...

did i miss something?
Hi,

Apoligies if i've been vague.

Columns A and B with data that never change, but on Column C, D and E are not.

Ex
A B C D E F
Name Address USD 100 Paid
Name Address USD 250 Pending


If i can move the data on column C to the right it will do the trick.