Macro Assistance [Solved/Closed]

Report
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
-
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
-
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.

3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010

Thanks for your help!
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010

I created the button and added your code, I rec'd a Runtime '9' error.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!