Lookup or Match
 

I have a master database I use to submit check requests, deposits, etc. Each
account type has it's own number and name. When I submit info. into the
master database, I would like the account info to automatically appear on
it's relevant worksheet with has the same columns. Example:

Master Database sheet:

Account Name Account# Amount
Library Revenue 3343 $25.00
Lost Books 2635 $20.00

How do I get the Library Revenue Info to automatically appear on the Library
Revenue worksheet?

I hope this is clear. Thank you for your time.

Hi Robbyn

Rather than duplicating data to other sheets, you could consider creating a
Pivot Table from your master database to give the results you want.
Take a lok at
http://www.contextures.com/xlPivot01.html
for soem guidance on setting up pivot tables and see if this will suit your
purpose.

--
Regards
Roger Govier
"Robbyn" wrote in message
...
I have a master database I use to submit check requests, deposits, etc.
Each
account type has it's own number and name. When I submit info. into the
master database, I would like the account info to automatically appear on
it's relevant worksheet with has the same columns. Example:

Master Database sheet:

Account Name Account# Amount
Library Revenue 3343 $25.00
Lost Books 2635 $20.00

How do I get the Library Revenue Info to automatically appear on the
Library
Revenue worksheet?

I hope this is clear. Thank you for your time.

Hi Roger,

Actually, that's a great idea. Thanks much for the advice.

Robbyn

"Roger Govier" wrote:

Hi Robbyn

Rather than duplicating data to other sheets, you could consider creating a
Pivot Table from your master database to give the results you want.
Take a lok at
http://www.contextures.com/xlPivot01.html
for soem guidance on setting up pivot tables and see if this will suit your
purpose.

--
Regards
Roger Govier
"Robbyn" wrote in message
...
I have a master database I use to submit check requests, deposits, etc.
Each
account type has it's own number and name. When I submit info. into the
master database, I would like the account info to automatically appear on
it's relevant worksheet with has the same columns. Example:

Master Database sheet:

Account Name Account# Amount
Library Revenue 3343 $25.00
Lost Books 2635 $20.00

How do I get the Library Revenue Info to automatically appear on the
Library
Revenue worksheet?

I hope this is clear. Thank you for your time.