Re: $$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)

2011-01-24 Thread Sandeep Kumar Maurya
Hi you can use the date function with offsset function in your reference formula for this. For exact formula tell me what's your current cell address having reference and whats the reference. On 23-Jan-2011 2:01 PM, "kush sharma" wrote: > Dear All, > > I have a query in which i need your help. Le

Re: $$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)

2011-01-23 Thread Ahmed Honest
Dear, That's possible. Please do a favour by sending a sample sheet of your query. I am sure you will get answer from the group. Regards Ahmed Bawazir On Sun, Jan 23, 2011 at 10:10 AM, kush sharma wrote: > Dear All, > > I have a query in which i need your help. Lets Say, I am using an Excel

$$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)

2011-01-23 Thread kush sharma
Dear All, I have a query in which i need your help. Lets Say, I am using an Excel sheet which has got multiple sheets inside it and a master sheet. Each Sheet is made for a different item that i sell. It has got colums such as Closing Balance(Yesterday), Inward and Outward and daily closing balanc