DATABASES

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?
--
bb

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

becky wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"becky" wrote:

> 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?
> --
> bb

Becky,

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

Debra

becky wrote:
> 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
>
> "becky" wrote:
>
>
>>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?
>>--
>>bb
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html