LinkBack URL
About LinkBacks
i want to copy c:\a.xls sheet1 count rows then copy column a3:a (uptil filled column)
paste in opened workbook sheet1 at a3
now copy c:\b.xls sheet1 count rows then copy column a3:a (uptil filled column)
paste in opened workbook sheet1 at b3
i want to copy c:\a.xls sheet1 count rows then copy column a3:a (uptil filled column)
paste in opened workbook sheet1 at a3
now copy c:\b.xls sheet1 count rows then copy column a3:a (uptil filled column)
paste in opened workbook sheet1 at b3
to the best of my knowledge, without using VBA, uou cant copy anything from a closed workbook. however, you CAN reference data from a closed workbook using a formula like this....
='[your-file-name.xlsx]sheet1'!cell-referance
you can then copy that down to where you need it to be, and if you want, copy/paste values
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
you may be right. then can i write such a macro which ask for file paths for the two xls files and then copy data from these files to this file and closes automatically but the file in which data is copied remain opened?
yes, the VBA can be written to extrad the data you want, and keep the "master" open
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks