I have a spreadsheet that has data ranging from C3:C263.
Workbook is 'GSU CAS Transactional Upload', Sheet is called 'Alliance Upload'
I need to have the data from C3:C263 to copy onto another workbook:
Workbook Location V:\NEPD Quality\Alliance Contingency, Workbook: CAS GROUP SETUP AUDIT.xlt, Sheet 'CAS Group Setup Audit', Range to copy to is D8:D268
I need that to run off a click of a button on the original workbook on 'Alliance Upload' sheet.
Workbooks("CAS GROUP SETUP AUDIT.xlt").Sheets("CAS Group Setup Audit").Range("D8:D268") = Workbooks("GSU CAS Transactional Upload.xls").Sheets("Alliance Upload").Range("C3:C263").Value
Hard to tell without seeing the book. Could you please upload sample files on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.