find text and move it

  • Thread starter Thread starter saman110 via OfficeKB.com
  • Start date Start date
S

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
 
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.
 
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,
Click to expand...
[quoted text clipped - 15 lines]
Tom 28 6 8 46 36
896 56 3 2 7 10
Click to expand...
Click to expand...
 
Back
Top