What I want it to do:
I have a macro selecting from a dropdown in cell "A2" sheet1 with 2 options
1st drop down option copies a row of values and formulas from sheet2 and paste them into "B2"
2nd drop down option copies a
The problem is I want to repeat this with a copied macro placed in "A3" with the same drop down option, the same 2 formula choices the only difference I want it to paste to"B3"
Then repeat this with A4, A5 and so on.
The Why:
2 different formula sets, one positive, one negative will calculate different data that is specific to that event.
The drop down text in "A:A" will label the row event for quick visual reference of it being a +ve or -ve event
The process is continuous and the events are random Hench the need for the macro in row "A"
The code I used works fine with a drop down macro in "A2" for row "2"
Sub Macro1()
Sheets("macroSelection").Select
Range("B2:R2").Select
Selection.Copy
Sheets("StartLloss03").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
End Sub
Sub Macro2()
Sheets("macroSelection").Select
Range("B3:R3").Select
Selection.Copy
Sheets("StartLloss03").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
End Sub
I have a macro selecting from a dropdown in cell "A2" sheet1 with 2 options
1st drop down option copies a row of values and formulas from sheet2 and paste them into "B2"
2nd drop down option copies a
different
row of values and formulas from sheet2 and paste them into "B2"The problem is I want to repeat this with a copied macro placed in "A3" with the same drop down option, the same 2 formula choices the only difference I want it to paste to"B3"
Then repeat this with A4, A5 and so on.
The Why:
2 different formula sets, one positive, one negative will calculate different data that is specific to that event.
The drop down text in "A:A" will label the row event for quick visual reference of it being a +ve or -ve event
The process is continuous and the events are random Hench the need for the macro in row "A"
The code I used works fine with a drop down macro in "A2" for row "2"
Sub Macro1()
Sheets("macroSelection").Select
Range("B2:R2").Select
Selection.Copy
Sheets("StartLloss03").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
End Sub
Sub Macro2()
Sheets("macroSelection").Select
Range("B3:R3").Select
Selection.Copy
Sheets("StartLloss03").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
End Sub