Can you link worksheets/workbooks

  • Thread starter Thread starter Karl Irvin
  • Start date Start date
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?
 
If you are in access, you can import and excel sheet. The
imported sheet becomes a table and you can link as usual.

Chuck
 
Back
Top