linking source workbook to other spreadsheets

[dolinger]

Is it possible to link specific rows in a source workbook
to update the same information in individual client
workbooks using the same information, saving time and
tedious input? Any help will be greatly appreciated.

 

[Don Guillett]

One way to learn how to do this is to have both open.
on the destination workbook put = in a cell
open the source workbook>goto the cell desired
press the enter key
close the source workbook
Now, it will update, open or closed.

Or use a macro

 

[A different Mike]

Is there a way that the cells in the destination workbook
can be linked so that if you type in the first cell (ie
type an item number) the second cell with the description
and a third cell on the row would fill in. The order of
the rows of cells would be different from the source
workbook to the destination workbook. Keying the first
cell would have to prompt a find in the data base
(source) workbook in order to have it find the correct
row containing the item description and UPC code.

Thank you for any help anyone may be able to give.

 

[Gord Dibben]

Mike

Sounds as if a VLOOKUP table may be what you need.

Check out Help for VLOOKUP.

Gord Dibben Excel MVP

 

[Guest]

EXACTLY what I needed THANK YOU!!!!!!

Mike

Sounds as if a VLOOKUP table may be what you need.

Check out Help for VLOOKUP.

Gord Dibben Excel MVP

 

[Gord Dibben]

Thanks for the feedback.

Always nice to know what works or doesn't.

Gord

On Wed, 23 Jun 2004 13:18:02 -0700, "A different Mike" <A different