how do you relate data between worksheets in MS excel?

Question

The same form you relate tables in Access, can you relate sheet within a excel workbook?

Answer 1

If I am understanding your question, you can make cells from one excel file go to another cell on a different excel file, you can also make it part of an equation. The easiest way for me is to have both files open and click what you want in the cell equation line, if that makes sense. Good luck.

Answer 2

As in one-to-many, many-to-one, many-to-many relationship? No you can't. You can try using fancy lookups tables with limits of course.