Forum Discussion
KrisCachia
Oct 22, 2020Copper Contributor
updating links from another spreadsheet
HI all, I am a still a newbie in excel and i am trying to do something simple but its not working as i want it to. I have 2 Employees spreadsheets, the basic and the detailed. the idea is t...
KrisCachia
Oct 23, 2020Copper Contributor
found the solution need to remove the $ before the row number
modified formula as follows:
from
=[basic.xlsx]Sheet1!$A$3
to
=[basic.xlsx]Sheet1!$A3
then when dragged down the formula all the row's formulas were properly updated to A4, A5, A6 respectively.
Problem solved 🙂
modified formula as follows:
from
=[basic.xlsx]Sheet1!$A$3
to
=[basic.xlsx]Sheet1!$A3
then when dragged down the formula all the row's formulas were properly updated to A4, A5, A6 respectively.
Problem solved 🙂
NikolinoDE
Oct 23, 2020Platinum Contributor
I was pleased that you were able to solve the problem yourself.
For further questions I am gladly at your disposal.
Have a nice day / night.
Nikolino
I know I don't know anything (Socrates)
For further questions I am gladly at your disposal.
Have a nice day / night.
Nikolino
I know I don't know anything (Socrates)