Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

?
Lv 7
? asked in Computers & InternetSoftware · 2 years ago

How to write formula to report one data to another file (XCELL)?

I keep my accounts on Excell.

I have prepared 2019, as blank, correctly dated.

I would like to have ONE data from the 2018 file be forwarded to the similar file in 2019...

Transfer from c;/.../accounts2018.xls/AH24 to c:/.../acoounts2019.xls/B24

How can I do that?

1 Answer

Relevance
  • ?
    Lv 7
    2 years ago

    Never mind. I found it:

    "=[filename][item]"

Still have questions? Get answers by asking now.