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 kushleshsha...@gmail.com wrote: Dear All, I have a query in which

$$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