Same values in different cells in row

Closed
sureshe Posts 2 Registration date Monday July 30, 2012 Status Member Last seen July 30, 2012 - Jul 30, 2012 at 09:41 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jul 31, 2012 at 10:01 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jul 31, 2012 at 10:01 AM
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
0