Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to set up reference to allow dragging
hi Group,
I have a formula that looks something like this: = CalcDiscount(ItemsSold FY2002) (where "CalcDiscount" is a macro function) I would like to be able to drag that formula across the row to fill in the remaining cells (for 2004, 2005, etc) But when I drag it, I get the SAME formula. Is there any way to set up the formula so that when one drags it, one would get: CalcDiscount(ItemsSold FY2003), CalcDiscount(ItemsSold FY2004), etc. Note that when the formula is just "= ItemsSold", and you drag that, you do get the ItemsSold in the column just above, in other words, the column reference changes (implicitly) to reflect the column where the formula is. In the situation above, I had initially tried this: = CalcDiscount(ItemsSold) hoping that the column reference would be implicit. However, the function rejected that parameter, because "ItemsSold" was defined as a (row) array, and the parameter expected was a cell.value reference. So, I had to add the column name. tiafah, jw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Automatically change tab reference | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
How do I reference multiple rows | Excel Worksheet Functions |