| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating formula when a worksheet is added
What does "shift and quit working" mean?
Can you share a "before" formula and an "after" formula--even if it fails? JakeShipley2008 wrote: I have a workbook that I will add new sheets to. I have created a amacro that will re-name all my worksheets to consectutive name e.g. CMM1, CMM2, CMM3, and so on as I add the worksheets. The data I need to pull is always from the same cells in each sheet. Normally I would pull it into the summary sheet with =sheet1!A1 but when I add the new sheets the formulas shift and quit working. Note: I am not summarizing the data I need to pull it over by individual cells Hopefully this makes sense I would appreciate any help you can offer. -- Jake -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating information in 1 file when it is added to other files | Excel Discussion (Misc queries) | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| updating caption of added control | Excel Programming | |||
| Updating formula with link to another worksheet using vlookup | Links and Linking in Excel | |||
| Setting a formula with code in worksheet added | Excel Programming | |||
Threaded Mode
