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 |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com