Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fairly Simple Macro HELP!
I need a macro that does the following:
Each row consists of an item (therefore the number of rows will vary), I need to drag a formula down a column (dragged down depending on the number of items are entered in) through the last item. Then I need a sum on those totals. Please help! Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fairly Simple Macro HELP!
Hi,
I think you right it probably is a 'simple macro' if a macro is even necessary but I'm afraid I don't understand the question Each row consists of an item (therefore the number of rows will vary), Please explain the above a bit more clearly and perhaps a small sample of data with the answer you expect. Mike "Lost" wrote: I need a macro that does the following: Each row consists of an item (therefore the number of rows will vary), I need to drag a formula down a column (dragged down depending on the number of items are entered in) through the last item. Then I need a sum on those totals. Please help! Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fairly Simple Macro HELP!
I need to drag a formula down a column
Besides Mike's question, tell us the formula you need to drag down so we can show you how to construct it in code (and make sure to tell us which, if any, references are absolute). -- Rick (MVP - Excel) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fairly Simple Macro HELP!
if your data is in column C and the first formula is in D1
then you could use Range("D1").AutoFill Destination:=Range(Range("C1"), Range("C1").End(xlDown)).Offset(, 1) Range("D1").End(xlDown).Offset(1).FormulaR1C1 = "=SUM(R1C:R[-1]C)" "Lost" wrote in message ... I need a macro that does the following: Each row consists of an item (therefore the number of rows will vary), I need to drag a formula down a column (dragged down depending on the number of items are entered in) through the last item. Then I need a sum on those totals. Please help! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help - Fairly Advanced. | Excel Worksheet Functions | |||
Help with fairly advanced list/print macro. | Excel Discussion (Misc queries) | |||
HELLLP!!!! This should be fairly simple I would think! | Excel Discussion (Misc queries) | |||
Fairly Complex IF Statement | Excel Worksheet Functions | |||
fairly basic excel question (i hope) | Excel Programming |