Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drag Formula Until ( )
Hello, Im working in a format in which the number of rows and columns it
occupies varies and I need to get some results from some sheets to other sheets and so on. A non-elegant way, which is how it is done right now, is to make sure I will not miss cells later on and just give the formulas to enough rows and columns, but it also makes the file much heavier... For example I have a 3 sheets in which the formulas and conditional formattings go all the way to column DG or so, one with "Quantity" other with "Price" and other with "Quantity * Price = Total" (input of new entries is horizontally). In this case I would like to for example have maybe a cell with "25" (the number of entries I need so far) and with that number have the cells containing formulas, formats, conditional formats, etc be dragged along for 25 columns... something like a INDEX but for dragging formulas I hope I was able to explain myself, thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drag a Named Formula | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
How do I set one cell as a constant so I can drag the formula | Excel Discussion (Misc queries) | |||
How do i "drag" a formula? | New Users to Excel | |||
How do I drag a formula from right to left columns instead of rig. | Excel Discussion (Misc queries) |