Forum Discussion
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...
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 🙂
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)