Macro Assistance

Solved/Closed
DCecil07
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
- Apr 21, 2010 at 10:01 AM
DCecil07
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
- May 7, 2010 at 09:52 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 21, 2010 at 10:30 AM
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
DCecil07
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010

May 7, 2010 at 09:52 AM
Thanks for your help!
0
DCecil07
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010

Apr 21, 2010 at 11:11 AM
I created the button and added your code, I rec'd a Runtime '9' error.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 21, 2010 at 11:16 AM
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.
0