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