Use counter to copy formulas
I have a named range "storecntr" that gives me the number of stores on a
worksheet. A formula is entered into cell A2 of another sheet that needs to
be copied down for all the stores. I want to use storecntr to tell how many
rows to copy the formula down, but as usual I'm having trouble because I
swear I have no logic. Any help would be appreciated. Thanks.
|