Guys,
I would like to use a macro which would return values from a CLOSED specific spreadsheet for which a cell reference is being generated (combination of vlookup, concetenate, etc...).
Please, see the attachment, it is very simple.
The value needed is on the sheet called "rozbor" in cell C85.
I cannot use PULL function, since it slows computer down, if I have more data to pull...
Any help highly appreciated!
Last edited by dan.zrust; 08-17-2013 at 08:49 AM.
Since you have the full address in the a cell, you can use that create a normal formula, then leave the value it created behind. Sort of a poor man's INDIRECT().
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks