How can I drag/autofill formula from source document in destination document
Hopefully this is an easy one. I have linked two documents. The source document is updated daily. The destination document is linked to the source document to pull certain values assigned to a certain cell.
Example: Cell C2 in the destination document is linked to Cell F5 in the source document. The data in the source document is entered horizontally, so I would like to be able to just drag the formula in C2 to D2 (in the destination document) and have the the data from Cell G6 (in source document) populate in Cell D2 (in destination document). Does this make sense?
I would like to be able to do this vertically as well. So, if I drag the formula in C2 to C3 (in destination document), it would pull the data from F6 (in source document).
If you understand this, can you please send me the steps to complete this function?
Thanks so much!