| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I expand formula down a column when query results change?
I have a spreadsheet that populates Column A through H via Microsoft Query.
Columns I through J are formulas using Columns A-H Each month the query is refreshed, when refreshed the rows of A-H can expand or contract If the current month is 100 rows and refreshes to 105 rows, the formulas from I-J do not copy down (nor do I expect them to) Looking for a way for when Columns A-H change, the related columns I-J also change. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a delay in formula results when I change one cell amount | Excel Discussion (Misc queries) | |||
| converting results from formula to text in a new column | New Users to Excel | |||
| How do I change formula results by changing the text color of the | Excel Discussion (Misc queries) | |||
| Formula to look up a column and paste results in another column | Excel Worksheet Functions | |||
| Formula results in font color change | Excel Worksheet Functions | |||
Threaded Mode
