LinkBack URL
About LinkBacks
harcor 
I have a sheet open and want excel to go and open another excel file in the same folder structure and copy over 2 columns from a specific sheet and then paste them back in my original sheet and close the newly opend file.
ANy help please
I have a sheet open and want excel to go and open another excel file in the same folder structure and copy over 2 columns from a specific sheet and then paste them back in my original sheet and close the newly opend file.
ANy help please
Sub Macro1() Workbooks("Book1").Worksheets(1).Range("A:B").Copy Workbooks("Book2").Worksheets(1).Range("A:B") End Sub
click on the * Add Reputation if this was useful or entertaining.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks