Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill in formulas for rows with data only.
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 |
#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 |
Reply |
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 |