[SIZE=12px]The code below does what I want but is it possible to activate the same range from a different named source workbook each time?
Ideally I didn't want any code in the source file.
I am doing this for a friend who has next to no knowledge at all with Excel. I know if she saves each order with the same name each time this will work from the destination workbook as below.
Any ideas would be appreciated. Thanks very much
Application.ScreenUpdating = False
' Windows("LOFtestvar.xlsx").Activate - SOURCE WORKBOOK
Windows("LJA databasetestvar.xlsm").Activate - DESTINATION WORKBOOK
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _