need formula/multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)

codysmom said:
HELP!!!........I have multiple worksheets in one workbook......One sheet
Click to expand...
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
 
Back
Top