DATABASES

[Guest]

I am trying to create a worksheet that has multiple tabs. Each tab needs to
have a database that uses information located on that sheet. However, I can
not get Excel to let me enter a database on the second sheet. It keeps
wanting to go look at the first sheet's formulas. How can I create a
database for each sheet in my workbook?

 

[Debra Dalgleish]

As answered at your previous post:

'=====================
Instead of using a workbook level range name (DB), you could use a sheet
level name:

Select the cells that you want to name
Choose Insert>Name>Define
In the Name box, type the sheet name, exclamation mark, and range name.
For example: 'Expense 1'!DB
Click Add, click Close

However, your JAN criteria range refers to the values on the Expense 1
sheet, so it won't work correctly for other sheets. On the Expense 2
sheet, you could use a DSUM formula:

=DSUM('Expense 2'!DB,3,FEB)

and in the criteria range use the formula:

=AND('Expense 2'!A7>=Criteria!$A$4, 'Expense 2'!A7<=Criteria!$B$4)

Or, instead of a DSUM formula, use SUMPRODUCT:

=SUMPRODUCT(--(A7:A36>=Criteria!A4),
--('Expense 1'!A7:A36<=Criteria!B4), --('Expense 1'!C7:C36))

 

[Guest]

Debra

Your suggestions were wonderful. I have thus far added 7 extra sheets and
gotton all of the formulas to work.

Thank you so much for the help.

Becky

 

[Debra Dalgleish]

Becky,

You're welcome, and thanks for letting me know that you got the formulas
working.

Debra