kram99 said:
I am trying to set up a workbook where if say cell D12 is true then link
cells A12,B12,C12 to workbook x or if cell D12 is false then link cells
A12,B12,C12 to workbook y can anyone help me ?
Are workbooks x and y the alternative sources, or are you trying to send
data to alternative destinations?
If they are alternative sources, you need formulas such as:
=IF($D$12,[Workbookx]Sheet1!A12,,[Workbooky]Sheet1!A12)
for open workbooks, or
=IF($D$12,'C:\Path\[Workbookx]Sheet1'!A12,'C:\Path\[Workbooky]Sheet1'!A12)
for a closed workbook.
The best way of entering such a formula is to have both source workbooks
open, then start typing the formula and when a cell reference is required,
navigate to that cell to get its reference. This way, you get the correct
syntax. It will automatically change when you close the source workbooks.
Having entered one formula in A12, you can copy to B12 and C12.
If you are trying to send data to alternative destinations, you cannot do
this. You are trying to 'push' data from one place to another. In Excel, you
'pull' data. So links between workbooks need to be entered in the
destination workbook, not the source workbook. You cannot put a formula in a
source workbook to send data to other workbooks.
