Happy new year

Thanks but i had already tried these functions that are not working on my data

"Max" wrote:

Perhaps INDEX/MATCH might provide a way out for you

There's a simple example he
http://www.freefilehosting.net/download/39kh9
Index n Match Example.xls

You should also check out Debra Dalgleish's
nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ruchi" wrote:
Actually i have all data in a workbook. one worksheet contains all day to
day data. and another sheet is its storage. how can i link the date cells of
both sheet so only once i have enter the data. simultaneously date is also
checked with the product column.each product is having seperate space in
storage sheet.
pls suggest something