Same values in different cells in row [Closed]

Report
Posts
2
Registration date
Monday July 30, 2012
Status
Member
Last seen
July 30, 2012
-
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
-
Hello,
Sub: Auto fill of Same value in different cells in a row using Macro button

Hi frnds,
Can anybody tel me how to auto fill of same value in different cells in a row?
For Example:
A1 D1 E1 G1 K1
10 10 10 10 10

like that when i hit a macro button the values in the A1 D1 E1 G1 K1 must fill with A2 D2 E2 G2 K2

Please help me.


Thanks

1 reply

Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
Hi sureshe,

This can easily be done by macro recording:
1. Goto top menu > Extra > Macro > record new macro.
2. A window appears, click OK. Notice another window appears to stop recording.
3. Now perform your actions.
4. Click on the stop recording button.
Congrats, you have recorded a macro.

Remove the value from A2 D2 E2 G2 K2 and run the macro (Alt+F8) to see if it works correctly.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!