Excel Problem
 

I have some sheets 1;2;3;4; ETC.................
I would like the new page list release with one botton:
A1-nome de sheet
A2-Date(C50:C80)
A3-Import (D50:D90)


Best regards

"Jerry W. Lewis" ha scritto nel messaggio
...
I am still not entirely clear about what you are trying to do, but the
=CELL("address",ref) includes the sheet name of ref, assuming that the cell
reference is on a different sheet. Assuming that Date is the only numeric
value (Excel dates are formatted numbers) in C5:C80, then you could use the
MAX() function to return its value. Similarly, MAX() could return Import
if Import is the only numeric value in D50:D90.

Jerry

SM wrote:

I'd like the Database with the
1-Name sheet
2-Data
3-Import
this data item are in more pages
and exactaly:
For example:
name page "sheet1"
2-Date (only date)situated betwin (C50:C80)
3-Import (only one import)situated betwin (D50:D90)


(Sheet1)
|A |B |C |D |
50
51 17/10/2005
52
53
54
55 Total ?. 150,00
56
57
__________________

(Database)
|A |B |C |D |
1 Sheet1 17/10/2005 ? . 150,00
2
3
4
5


Tanks

Marcello


"Jerry W. Lewis" ha scritto nel messaggio
...

I suspect that you have not received a reply because no one else can make
any more sense of your post than I have. Can you explain what you want
more fully? An example would probably help too.

Jerry

SM wrote:


I have some sheets
In every sheet i have a date betwin C50:C80
and the import betwin D50:D90
Is possible that the solution is in other sheet.............? 1-Name
sheet
2-Date (C50:C80)
3-Import (D50:D90)

Thanks

Marcello