Good Day all.

I have a spreadsheet which calculates the cost of insulating a piece of equipment.. The sheet consists of numbers 1 through 10 which gives user 10 different pieces of equipment to estimate cost. I would like to be able to have just one line at top of sheet and a simple macro which in the cell will say add equipment, when button to add is clicked it would add another line with the same calculations from the original so user can estimate 1 to 100 pieces of equipment without me having to have 10 sheets for them to do so.


thanks
mike