Hello everyone,
I'm trying to create a macro which takes selected cells and imprints them on a form with a specific template. I'd like to have most of the information from the "Payout Tracker" imprint to the "Internal Payment Request Form" [shown below]. My trouble is that I'll be adding columns on the "payout tracker" while the "Internal Payment Request Form" will remain stationary.
I've managed to code the original selection:
Sub CopyProfilePRC()
'
' CopyProfilePRC Macro
' Copy payment Cells to profile PRC
Selection.Copy
Cells.Find(What:="Date of Invoice").Select
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues
End Sub
My question is: Can I select a cell (2) & (3) in reference the original selection (1) through VBA?
Thank you
I'm trying to create a macro which takes selected cells and imprints them on a form with a specific template. I'd like to have most of the information from the "Payout Tracker" imprint to the "Internal Payment Request Form" [shown below]. My trouble is that I'll be adding columns on the "payout tracker" while the "Internal Payment Request Form" will remain stationary.
I've managed to code the original selection:
Sub CopyProfilePRC()
'
' CopyProfilePRC Macro
' Copy payment Cells to profile PRC
Selection.Copy
Cells.Find(What:="Date of Invoice").Select
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues
End Sub
My question is: Can I select a cell (2) & (3) in reference the original selection (1) through VBA?
Thank you