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" <[email protected]> wrote: > 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 balance. using > cross-linking the master sheet gets updated with the closing balance for > that partiular itme. but the next day i have to change the cell reference > for each item closing balance (cell reference) in the master sheet. I just > have to delete thatparticular cell number and replace it with next row > number but is there any formula which can automatically take next cell as > reference if the date changes? or any thing else that can help me in this. > > > I would apprecaite the help > > *Regards* > * * > *Kushlesh Sharma* > *Mo.No: 9907517169* > ** > > "All Things are subject to interpretation, and whichever interpretation > prevails at a given time is a function of power not truth". > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
