displaying data from another workbook
I need to constantly display data in cell "C12" of the active workbook. The data is from cell "A1" of another closed workbook. Basically copy the data from "A1" of a different workbook to cell "C12" of the active workbook.
Any help would be greatly appreciated!
Thanks!
in the where you want the data shown, just type the reference...or open the other file (just once off), type = then point to the cell onthe other workbook, and press enter
something like...
='[referencesheetname.xlsx]Sheet1'!$A$1
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
Thank you!
But i need to constantly update the values. Like every time I open the workbook. How can I do that?
Also the second workbook is closed...
that will always reference the value from the closed workbook in that cell. however, if something else feeds into the closed workbook, that closed workbook will not updarte itself until it is opened.
so, whenwever you open the workbook that references the closed workbook, the last saved value from the closed workbook will be shown
The code works perfectly! Thank you very much!
you'r welcome. If this answered your question, please take a moment to mark the tread as "solved", and consider adding the reputation to those that helped (see points 2 & 3 below
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks