Forum Discussion
Retrieving data from another closed Excel-file
Hi! I have two Excel-files saved on Teams in seperat folders. One of the Excel-files is retrieving data from the other (source document). I have noticed that when I add a row in the source docum...
Hi..
how are you retrieving the data ?
Regards, Faraz Shaikh
how are you retrieving the data ?
Regards, Faraz Shaikh
- Hi Faraz,
I retrieve it by typing "=" and then choosing the cell in the source document with the data I want to retrieve.Frallan13 wrote: I retrieve it by typing "=" and then choosing the cell in the source document with the data I want to retrieve.
The "=" part is given. Then we have to ask "How to you choose the specific cell in the source document?" Do you remember the column and row address?
I have a master spreadsheet that pulls in data from two source sheets. I usually have the source sheets open when doing so, so this may not be relevant. From time to time the numbers of rows in the source sheets change, sometimes up, sometimes down. I use COUNT to count the rows, and then INDIRECT to modify references accordingly. Something for you to try if it's at all relevant.
- Okay!
Well for exampel I retrieve A2, C2, E2, V2, W2 and AB2 from the source file and also the same columns for row 4, but not for row 3 which is irrelevant for the retrieving document.
Can you type the function you type with COUNT and INDIRECT that you use?
Then it might be easier for me to understand how to use them.
