Any Formulas that simply copy cells and paste them farther down a row?

rhelm

New Member
Joined
Mar 20, 2019
Messages
17
Greetings,

Example:
I've got data in Row3 A2 B2 D2. Once that data has been reviewed/confirmed, I need to COPY/PASTE it over to M2, N2, and Z2 on the same Row.
Then wash, rinse, repeat down each Row.

Might that be possible via a Formula? I can't seem to find anything. Or would this be limited to a vba macro?

Any examples of either? :confused:

Best Regards,
rhelm
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Depends what type of method you are using.

in M2
=IF(E2="Y",A2,"")

in N2
=IF(E2="Y",B2,"")

in Z2
=IF(E2="Y",D2,"")

If you put Y in E2 the values will get transferred to M2 N2 Z2
Copy the formulas down the column for as many rows as you need.

NOTE: If you delete the Y or change it to anything else in column E then the values will disappear from M2 N2 Z2.

If this is not what you want then the only other solution is VBA.
 
Upvote 0
Thanks, I'll give that a go. Question, if I do it in VBA, how do I adjust the below macro to not be row specific? Meaning, after that I3 to V3 has been ran, now I want to use it on Row8 I8 pasted on to V8.

Sub Macro1()
Range("I3").Select
Selection.Copy
Range("V3").Select
ActiveSheet.Paste
End Sub
 
Upvote 0
How about
Code:
Sub rhelm()
   Range("V" & Selection.Row).Value = Range("I" & Selection.Row).Value
End Sub
This will copy the value in col I to col V for whichever row is selected
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top