| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Storing Formulas to Use
Is there a way to store formulas in a worksheet, for instance----
=IF(ISNA(VLOOKUP(A4,'2005 information'!$A$4:$L$97,12,FALSE)),"No Client Info For This Year",VLOOKUP(A4,'2005 information'!$A$4:$L$97,12,FALSE)) ----- So that it will automaticall pull if a new worksheet is created. Basically I want to make a Comparison worksheet, and when a new year comes like 2006, I want ot be able to pull in my 2006 worksheet, and have the formulas update automatically to 2006, so that I don't have to change them to 2006. Is this possible to do???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| locking formulas?? | Excel Discussion (Misc queries) | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Threaded Mode
