need formula/multiple worksheets


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
 
Ad

Advertisements

B

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)

codysmom said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top