| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
Hello everybody:
is it possible to have a macro or whatever to "replicate" the formulas in the next row so that I have the formulas only in the cells I am actually going to use and not on all the empty rows? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas
You can make the formula cells "invisible". Suppose you have data in columns
A & B. In C1 you have =A1+B1. You would have to copy the formula down to cover the A's and B's you have entered. Instead enter =IF(A1="","",A1+B1) in C1 and copy this down. The formula will be blank until you put non-blank values in A,B -- Gary''s Student "antonov" wrote: Hello everybody: is it possible to have a macro or whatever to "replicate" the formulas in the next row so that I have the formulas only in the cells I am actually going to use and not on all the empty rows? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming | |||
Linear Mode
