Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coping formula down
If i have a form that user enters info, hits add and it adds data say columns
a-d how do i get the formulas i have in say columns e through g to fill in the same number of rows of data i now have. I have always done it the easy way just copying down 100 rows but I want to build this so i don't have to come back later when the data exceeds 100 rows. Do you got me? Thank you- Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coping formula down
Dear Jennifer.
When ever you copy a formula and you want to past it into other cell use "past special" in this feature you will see different choice; in your case use €œFormula" so it will past the same formula you coped. Hold the Ctrl Key and past as many as you wish. Another way of pasting formula, copy the formula and highlight the cells and past special and then formula. I hoop I helped you. My email is: "Jennifer" wrote: If i have a form that user enters info, hits add and it adds data say columns a-d how do i get the formulas i have in say columns e through g to fill in the same number of rows of data i now have. I have always done it the easy way just copying down 100 rows but I want to build this so i don't have to come back later when the data exceeds 100 rows. Do you got me? Thank you- Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coping formula down
Assuming row 1 has headers and your formula is in row 2, this will copy the
formula in E2 down to the last entry below D2: Range("E2", Range("D2").End(xlDown)).Offset(0, 1).FillDown Mike F "Jennifer" wrote in message ... If i have a form that user enters info, hits add and it adds data say columns a-d how do i get the formulas i have in say columns e through g to fill in the same number of rows of data i now have. I have always done it the easy way just copying down 100 rows but I want to build this so i don't have to come back later when the data exceeds 100 rows. Do you got me? Thank you- Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for coping a cell from a diffent sheet | Excel Discussion (Misc queries) | |||
coping formula | New Users to Excel | |||
coping formula | New Users to Excel | |||
Coping a formula | Excel Discussion (Misc queries) | |||
formula coping 5 consecutive cell triggered by a value from anoth. | Excel Discussion (Misc queries) |