Function Help

[Erika]

I have several worksheets with different company info on each sheet - I also
have one master worksheet that lists all the information for all the sheets.
Is there a formula\function that I can set up that when I enter a company
name and fill in all the required information - it will automatically copy
that same entry to the appropriate worksheet.

Example

Master Workbook - I have several entries for Company A. if I add another
entry for company A or modify and existing entry - I want to see that
reflected on the Worksheet tab entitled Company A.

Any ideas?

[Bernie Deitrick]

Erika,

Don't use sheets for the individual companies. Use one sheet, one database, and use autofilters to
show the information for the company of interest. Having the same information entered in multiple
places is a recipe for disaster - or, at least, occasional confusion.

HTH,
Bernie
MS Excel MVP


"Erika" <[email protected]> wrote in message
news:[email protected]...
>I have several worksheets with different company info on each sheet - I also
> have one master worksheet that lists all the information for all the sheets.
> Is there a formula\function that I can set up that when I enter a company
> name and fill in all the required information - it will automatically copy
> that same entry to the appropriate worksheet.
>
> Example
>
> Master Workbook - I have several entries for Company A. if I add another
> entry for company A or modify and existing entry - I want to see that
> reflected on the Worksheet tab entitled Company A.
>
> Any ideas?

[CLR]

Personally speaking, this sounds lika another one of those situations where I
would forget about the separate worksheets for each company and maintain all
my data in the master database. I can generate separate reports for each
company on demand with the AutoFilter, and if necessary, copy it to another
sheet to manipulate, and/or format for printing.......I would strongly
question what benefit having the separate sheets provide you and only proceed
in that direction if absolutely necessary.

hth
Vaya con Dios,
Chuck, CABGx3



"Erika" wrote:

> I have several worksheets with different company info on each sheet - I also
> have one master worksheet that lists all the information for all the sheets.
> Is there a formula\function that I can set up that when I enter a company
> name and fill in all the required information - it will automatically copy
> that same entry to the appropriate worksheet.
>
> Example
>
> Master Workbook - I have several entries for Company A. if I add another
> entry for company A or modify and existing entry - I want to see that
> reflected on the Worksheet tab entitled Company A.
>
> Any ideas?