 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008copy and autoadjust formula
I have a workbook with many consecutive sheets (one for each day)In 3 different cells (on the same location in every sheet) there is a formula, which comes from the previous sheet. Eg: C3Tuesday='Monday!F3. How can I copy these formulas so that they autoadjust from sheet to sheet, and I dont have to do it manually. Thanks beforehand If you're willing to use a User Defined Function....... Function PrevSheet(rg As Range) n = Application.Caller.Parent.Index If n = 1 Then PrevSheet = CVErr(xlErrRef) ElseIf TypeName(Sheets(n - 1)) = "Chart" Then PrevSheet = CVErr(xlErrNA) Else PrevSheet = Sheets(n - 1).Range(rg.Address).Value End If End Function =PrevSheet(F3) Note: you can group the worksheets from 2 onwards and enter the formula on the activesheet. Will be entered in all sheets except first sheet. Gord Dibben MS Excel MVP >I have a workbook with many consecutive sheets (one for each day)In 3 >different cells (on the same location in every sheet) there is a >formula, which comes from the previous sheet. Eg: C3Tuesday='Monday!F3. >How can I copy these formulas so that they autoadjust from sheet to >sheet, and I dont have to do it manually. Thanks beforehand |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.