I have a spread sheet that is grouped where the top line of the group
determines the Qty of Item and the Total value for the item

eg 1 Table (row 1) requires 1 table top, 2 chairs and 4 legs (rows 2 to 4)
if I change the qty in Row 1 (i.e. No of Tables)  the parts automatically
change as well.

eg
               Col A        B              C                 D
E
               Qty                          Unit
                             formula       Rate                Value
Total
Row 1        1
300
Row 2        2          A2*A$1     50                      100
Row 3        1          A3*A$1    100                    100
Row 4        4          a4*A$1      25                    100

I want to be able to copy this grouping so that the formula in column B (the
A$1 part)  always refers to the relative Row 1 of the group i.e if I copy
and insert the group at Row 6 the formula in Row 6 would change to A7 * A$6
etc

Is there a way of using a command button to copy the group and then paste it
into the spreadsheet at the row that has been selected and then update the
formula in the rows with the row number of the insertion point

eg it copies the group , I then select row 13 as the insertion point, this
row number is stored in a variable, so that the formula in row 14, 15 and 16
is updated to A14*A$13, A15*A$13 and A16*A$13

I do have some knowledge of VBA but in Access not Excel so a dummies guide
would be much appreciated to any solution that may be offered

Thanks