linking (?) fields between Excel docs

[Kateapotomous]

Hi all-
didn't know exactly what to call this, so my apologies if this has been
covered before.

Here's what I want to do:

1) my company has Excel Sales Orders with many different fields --
dates, dollars, contacts, etc.

2) at the end of the week certain information form the Sales Orders
needs to be transferred to an Excel Summary Sheet -- rows and columns
set up. This is currently a cut and paste operation.

My question is: can I reformat our existing Sales Orders (and Summary
Sheet I imagine) so that once the required information is entered into
the Sales Orders and then the Summary Sheet is opened, the Summary
Sheet will update and populate automatically with the information from
the Sales Order?

Thanks in advance for any help/advice!

 

[Guest]

This newsgroup is for Access, the database system portion of Microsoft
Office. I suggest you ask your question in an Excel newsgroup. However,
here is a formula from one of our spreadsheets that references data in
another that may be a helpful example:
=VLOOKUP(A14,'\\rsltx1-bm01\busmgmt\VOUGHT 2004\Actuals\September\[Activity
#''s as of 9-27-2004.xls]Sheet1'!$C:$D,2,FALSE)