Are your daily reports each on a separate sheet?

How are named the sheets?

You can use INDIRECT on monthly sheet.

HTH
--
AP

"imran" a écrit dans le message de
...
sir, i m preparing the a daily report, in which i add the figure, in the
last of month , i have to prepare a monthly summary , that i prepare
manually, in the summary,

for example , this month of april, i give the date in the date cell,all
data fill into the daily report. now in monthly summary report ( i have
already prepare the monthly report by date wise from 1~30),
like this :

for example
this is my daily summary
date 4/1/06
this is my data that i write into the cells
parameters value
count 12.1
cv 1.2
clsp 2340
cvb 2.5

now in montly summary,

date count cv clsp cvb
4/1 12.1 1.2 2340 2.5
4/2 12.5 1.4 2340 3.1
4/3
4/4
up to
30/4

now i want my 4/1 values automatic add into the all parameters , and
next day when date change, in montly summary automatic data transfer to
4/2 's parametes,

is it possible in excel or not