Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response