Can you link worksheets/workbooks

K

Karl Irvin

In Access I can "link" a table of invoices (which have a customer number) in
them with a table of customers which has the customers address etc. in it
and produce a report of invoices and all the related customer information.
Can you do that in Excel?
 
C

Chuck

If you are in access, you can import and excel sheet. The
imported sheet becomes a table and you can link as usual.

Chuck
 
Top