mattpolyak
New Member
- Joined
- May 1, 2015
- Messages
- 7
To simplify a previous question that got no response:
Lets say you have two workbooks. One has a value of 1 or two in Cell A1.
The second has a formula that reads: (=IF('C:\Users\Mattpolk\Desktop\[source.xlsx]Sheet1'!$A$1=2,2,IF('C:\Users\Mattpolk\Desktop\[source.xlsx]Sheet1'!$A$1=1,1,0)) in cell A1 and A2. with a sum of A1 and A2 in cell A3
In cell A2 in the first book should be the value of A3 in the second book.
I need cell A2 in this first book to change and update when I change cell A1 to 1 or 2 while workbook 2 is closed.
Is this possible?
Lets say you have two workbooks. One has a value of 1 or two in Cell A1.
The second has a formula that reads: (=IF('C:\Users\Mattpolk\Desktop\[source.xlsx]Sheet1'!$A$1=2,2,IF('C:\Users\Mattpolk\Desktop\[source.xlsx]Sheet1'!$A$1=1,1,0)) in cell A1 and A2. with a sum of A1 and A2 in cell A3
In cell A2 in the first book should be the value of A3 in the second book.
I need cell A2 in this first book to change and update when I change cell A1 to 1 or 2 while workbook 2 is closed.
Is this possible?