excel creating a macro that will adjust to parallel cells automatically

hi i currently have an excel in which i record all customers data. order number, name, product, amount paid, i have another workbook that i created an invoice in. i want to copy the relevant informat...

excel

Mark Fitzgerald

Iron Contributor

Dec 06, 2017

Could you post your code, a redacted sheet showing orders and how you expect the invoice to look?

Yehuda Macmull

Copper Contributor

Dec 06, 2017

Thanks for your help. i have included two screen shots. the first one is my excel with customers in. the second is a different workbook with the invoice. i would like to create a button that will automatiically copy on the same line the order number, product name, amount paid and date to the relevent cells in the invoice workbook. this is the code i have currently

ActiveWindow.ScrollColumn = 2
Range("A13").Select
Selection.Copy
Sheets("invoice").Select
Range("E9").Select
ActiveSheet.Paste
Sheets("DECEMBER").Select
Range("B13").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("invoice").Select
Range("E12").Select
ActiveSheet.Paste
Sheets("DECEMBER").Select
Range("J13").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("invoice").Select
Range("D18").Select
ActiveSheet.Paste
Sheets("DECEMBER").Select
End Sub

thanks for your help

Forum Discussion

excel creating a macro that will adjust to parallel cells automatically

Resources