| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in formulas for rows with data only.
Rory,
Please email me a copy of your spreadsheet & I will examine it. -- http://HelpExcel.com "rory_r" wrote: Firstly thanks to all the help in this forum. I have a spreadsheet with 1 row of 14 columns of data and 6 columns of formulas to perform various calcs on the first 14 columns. I copy paste data into the rows below and drag the 6 columns of data down to the end of the data which some days are 200 rows sometimes 2000. I tryed dragging the formulas first and saving the form before pasting but it slows the calcs down on light days too. I have a macro that pastes and configures the columns for conditional formatting etc. I'd like to have a macro that then drags the last 6 columns down to the last row with data on it only. Any ideas? Again thanks in advance. Rory |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill all rows in sprdsht with data above it | Excel Discussion (Misc queries) | |||
| Fill Data with formulas with Absolute References | Excel Discussion (Misc queries) | |||
| Fill Data across multiple Worksheets - Formulas | Excel Discussion (Misc queries) | |||
| Fill formulas into adjacent cells does not take formula only data | Excel Worksheet Functions | |||
| Import External Data -- Fill down formulas Issue | Excel Worksheet Functions | |||
Threaded Mode
