Hi Excel buddys!

i have 2 problems, one i need a macro or similar to add a new line on click (based on the above line). I also need this to allow totals to be calculated at the end of the form, so when the button is clicked the totals drop down a cell and a new line is added.

the other problem i have is How to Pull data from 2 cells into another sheet i only want them to be pulled if they are number Not is they have "RD" or "SP" in the target cell. then once transferred into the destination cells to sort from Cell B1 to B30 in number order.

is this possible and if anyone can help id appreciate! iv been racking my brain for ages on these and trying to combine all sorts of bits iv found, to no avail.

regards
chris