linking source workbook to other spreadsheets

D

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.
 
D

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

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.
 
G

Gord Dibben

Mike

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

Check out Help for VLOOKUP.

Gord Dibben Excel MVP
 
A

A different Mike

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

Gord Dibben said:
Mike

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

Check out Help for VLOOKUP.

Gord Dibben Excel MVP
Click to expand...
 
G

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
 
Top