Hi All,

I am trying to update values on a particular cell item on worksheet A. however, the worksheet on which I am looking for data is saved as a new worksheet everyday based on dates. My question is, is there a macro I can create that would look straight into the newly saved workbook?

thanks
Hiren.