Referencing cells in separate work books

Hi Dan

Thank you for posting your question on our forum.

It all depends on the structure of your data on different workbooks and how you want to reference the data. If you have source data in workbook #1 and you know it won't be filtered/sorted at all then the other workbook (#2) can reference the cells just by creating links.

However, if workbook #1 is going to be filtered/sorted, then links to cells will not reference the correct data. In this case you will need a Lookup formula in workbook #2 to look up a unique id number in workbook #1. Examples include VLOOKUP, MATCH and XLOOKUP.

Here is a Youtube video of how to get started with VLOOKUPS:

https://www.youtube.com/watch?v=hwL6KKJP-_I

As your question is quite general, it may help to be more specific in exactly what you mean by referencing cells.

Please let us know how you get on

I hope this helps

Kind Regards
Martin