find text and move it

[saman110 via OfficeKB.com]

Hi,

In col. A I have text and numbers. and in col. B,C,D,E,F I have numbers. I'm
looking for a macro that looks in Col.A and find texts and move row A,B,C,D,E,
F One to the right.

thx,


ex.

A B C D E F G
Tom 28 6 8 46 36
896 56 3 2 7 10



Result.

A B C D E F G
Tom 28 6 8 46 36
896 56 3 2 7 10

 

[Guest]

Hi,

Really no need for a macro -
1. Select the data in column A
2. Press F5, Special
3. Turn on the Constants option and uncheck Numbers, Logicals, and Errors
then click OK
4. Press Ctrl+Shift++ (plus sign) and choose Shift Cells to Right.

If you need it in a macro, you can record it.

 

[saman110 via OfficeKB.com]

It worked great.

Thank you.

Hi,

Really no need for a macro -
1. Select the data in column A
2. Press F5, Special
3. Turn on the Constants option and uncheck Numbers, Logicals, and Errors
then click OK
4. Press Ctrl+Shift++ (plus sign) and choose Shift Cells to Right.

If you need it in a macro, you can record it.

Hi,

[quoted text clipped - 15 lines]

Tom 28 6 8 46 36
896 56 3 2 7 10