Macro Assistance Solved/Closed

Question

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.

Let me know if that is confusing.

Thanks.

Configuration: Windows XP / Internet Explorer 6.0

rizvisa1 · Answer

try this. It is assuming both books are open

Sub copyData()

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

End Sub

DCecil07 · Answer

I created the button and added your code, I rec'd a Runtime '9' error.

rizvisa1 · Answer

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.

Macro Assistance

3 responses

Similar discussions

Subscribe To Our Newsletter!