Data Binding

I

info

Hello,

I have a spreadsheet that has 12 tabs, one for each month. I want to move
all the raw data to one tab in a database and have another tab reference
the data based on which month you choose. <--- This is the easy part.
The issue I am having is that when you update the info or add new info how
can I bind the data to the database? Access would be so much easier but
stuck in excel...

Ernst.
 
M

Myrna Larson

Generally you define a named range that used a formula, i.e. in the RefersTo
box you type something like this:

=OFFSET($A$1,0,0,COUNTA($A$1:$A$65536),N)

Replace N with the number of columns (which I assume to be constant). The
formula also assumes that there are no embedded blank cells in column A.
 
I

info

OK... My Database Range is 'RawData!B3:L369' On the Cash sheet tab I can
use formulas to lookup sales on a particular day.

Day Date Weather Info 11 - 12pm 12 - 6am 6 - 11am 11 - 2pm 2 - 5pm 5 - 8pm 8
- 10pm 10 - 11pm





Thur 01
Jan sun/cold 120.92 975.41 460.92 1,356.08 1,080.36 992.08 866.49 239.34
Fri 02
Jan snow 153.45 308.34 618.56 2,227.43 1,503.09 1,106.73 693.66 137.00
Sat 03
Jan rain/cloudy 161.59 602.85 792.24 2,197.56 1,550.61 753.08 322.32 134.15

in the 11-12pm slot I can look up that data with a formula. No prpblem.
But if I want to change the data... It will override the formulas... I want
to bind the cell to the database. I'm not sure your formula helps me or
maybe I don't see where you are going with it.

Ernst.
 
Top