Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic formula
Hi all
I am trying to create a formula that will gather information located on different worksheets. I am trying to do this dynamically by creating a macro that will "rebuild" the formula after a new sheet is added. The data is located in the same cell on each sheet. I figured that I could write a for next loop that will parse through all the work sheets and add the cell to the formula. I am not a super programmer but I can get by so if someone can point me in the right direction, I would appriciate it very much thank You. -- Mark Smith SPX Air Gage Co. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic formula
You can do this with a macro, but why not use dummy hidden sheets as your
first and last sheets? Name them "First" and "Last" and hide them. Any new sheets that you insert will be between the two hidden sheets. Then the formula: SUM(First:Last!A1) will sum all the A1s no matter how many new sheets you insert. -- Vasant "Mark Smith" wrote in message ... Hi all I am trying to create a formula that will gather information located on different worksheets. I am trying to do this dynamically by creating a macro that will "rebuild" the formula after a new sheet is added. The data is located in the same cell on each sheet. I figured that I could write a for next loop that will parse through all the work sheets and add the cell to the formula. I am not a super programmer but I can get by so if someone can point me in the right direction, I would appriciate it very much thank You. -- Mark Smith SPX Air Gage Co. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic formula
THANK YOU!!!!
That was very easy. -- Mark Smith SPX Air Gage Co. "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... You can do this with a macro, but why not use dummy hidden sheets as your first and last sheets? Name them "First" and "Last" and hide them. Any new sheets that you insert will be between the two hidden sheets. Then the formula: SUM(First:Last!A1) will sum all the A1s no matter how many new sheets you insert. -- Vasant "Mark Smith" wrote in message ... Hi all I am trying to create a formula that will gather information located on different worksheets. I am trying to do this dynamically by creating a macro that will "rebuild" the formula after a new sheet is added. The data is located in the same cell on each sheet. I figured that I could write a for next loop that will parse through all the work sheets and add the cell to the formula. I am not a super programmer but I can get by so if someone can point me in the right direction, I would appriciate it very much thank You. -- Mark Smith SPX Air Gage Co. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic formula
You're most welcome! :-)
-- Vasant "Mark Smith" wrote in message ... THANK YOU!!!! That was very easy. -- Mark Smith SPX Air Gage Co. "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... You can do this with a macro, but why not use dummy hidden sheets as your first and last sheets? Name them "First" and "Last" and hide them. Any new sheets that you insert will be between the two hidden sheets. Then the formula: SUM(First:Last!A1) will sum all the A1s no matter how many new sheets you insert. -- Vasant "Mark Smith" wrote in message ... Hi all I am trying to create a formula that will gather information located on different worksheets. I am trying to do this dynamically by creating a macro that will "rebuild" the formula after a new sheet is added. The data is located in the same cell on each sheet. I figured that I could write a for next loop that will parse through all the work sheets and add the cell to the formula. I am not a super programmer but I can get by so if someone can point me in the right direction, I would appriciate it very much thank You. -- Mark Smith SPX Air Gage Co. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic formula | Excel Worksheet Functions | |||
How to convert a static formula to dynamic formula ? | Excel Worksheet Functions | |||
Dynamic Formula with Dynamic Address | Excel Worksheet Functions | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel |