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

[rhelm]

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?

Best Regards,
rhelm

 

[Special-K99]

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.

 

[rhelm]

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

 

[Special-K99]

I'm no VBA expert I'm afraid.

 

[Fluff]

How about

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

 

[rhelm]

That'll work, Fluff. Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback