need formula/multiple worksheets

[Guest]

HELP!!!........I have multiple worksheets in one workbook......One sheet is "General Inventory"; other worksheets are named for the individual shops that I deal with....The sheets are set up with column names such as: Item #, Description, Size, $, etc...The General Inventory sheet also has a column for each of the shops.....I'd like to be able to work on the General Inventory sheet and have it automatically update the respective individual shop worksheet....I'm driving myself crazy with how to do this......I'd really appreciate any / all help with this......Thanx

 

[Bob Phillips]

There are probably many ways that this can be done, add formulae on the
individual sheets such as

='General Inventory'!A1 etc

or use VBA event code to add it, but I think we would need more details to
offer better, more specific help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

HELP!!!........I have multiple worksheets in one workbook......One sheet

is "General Inventory"; other worksheets are named for the individual shops
that I deal with....The sheets are set up with column names such as: Item #,
Description, Size, $, etc...The General Inventory sheet also has a column
for each of the shops.....I'd like to be able to work on the General
Inventory sheet and have it automatically update the respective individual
shop worksheet....I'm driving myself crazy with how to do this......I'd
really appreciate any / all help with this......Thanx