I have a user input column (A:A) where the user puts in Product name
there are then several formulas in B2, C2, D2, Etc and I want to run
a macro that will copy those down to as far as the data extends in
column A. i.e if the product name runs to A10 the user can then press
a button and all formulas will copy down to B10, C10, D10, etc.
Or is there a better way of doing this?