Linking Spreadsheets
Solved/Closed
Dohnutter
-
Feb 13, 2010 at 11:00 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 13, 2010 at 01:58 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 13, 2010 at 01:58 PM
Related:
- Linking Spreadsheets
- Functions on spreadsheets - Guide
- They are interfaces for linking devices by using cables - Guide
- Disadvantages of linking instagram to facebook - Guide
- Linking data from one spreadsheet to another - Guide
- Find missing data between two spreadsheets - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 13, 2010 at 01:58 PM
Feb 13, 2010 at 01:58 PM
It seems that at the end of the day some how INDIRECT would be required. But the catch for indirect would be that the other book needs to be opened too
One way of getting what you want can be via use of public function
Then in your call to function you say some thing like
=INDIRECT(getValue("Invoices.xls", C3, "$H$44"))
or get the value in the function itself
One way of getting what you want can be via use of public function
Public Function getValue(bookname As String, sheetname As String, address As String) As Variant temp = "'[" & bookname & "]" & sheetname & "'!" & address getValue = temp End Function
Then in your call to function you say some thing like
=INDIRECT(getValue("Invoices.xls", C3, "$H$44"))
or get the value in the function itself