I have a little amount of data that changes constantly that I need to move from one file and past amongst 8 different tables. I'm new to working with vba on excel, but trying to learn. Any assistance would be appreciated.
I keep getting a script out of range.
Thank you
VBA Code:
Workbooks("Phone import prep book.xlsm").Worksheets("Dataset").Range("A3:a102").Copy
Workbooks("import_test.xlsx").Worksheets("Basic").Range("C11:C110").PasteSpecial xlPasteValues
Workbooks("import_test.xlsx").Worksheets("Handle").Range("B11:B110").PasteSpecial xlPasteValues
Workbooks("import_test.xlsx").Worksheets("CM Endpoit Profile").Range("AI11:AI110").FormulaR1C1("R[35]C[11]:R[35]C[110]").PasteSpecial xlPasteValues
I keep getting a script out of range.
Thank you