dynamic list problem

[RobShaw]

I have a sheet that looks a bit like this
__C___D_____E___F____G________H
Qty Model RRP Cost total_RRP total_cost
3 {lookup information}
4 {blank}
5 {blank}
6


Now the look up nformation is copied to row 6 on a command button click. using cells.find, the next time each copy is put on the row beneath the last starting at C6 (there are some other columns etc. but there are irrelavant to this.

After the row is copied, another set of cells.find's run to sum the columns and enter the values beneath the columns. I have a recalculate button that wipes this sum row and recalculates them columns (the user can over ride the sale price etc.) but I need to copy the formula from cells g3 and H3 back into each of the rows from G6 onwards. i.e. when the qty is altered, I need it to recalculate the value, currently only the outcome of the formula is put in the total columns, not the formula itself, any ideas?

 

[RobShaw]

apologies for the spacing problem previously, how do I paste a pic?

 

[Harvey]

I don't completely understand your question. From what I understand is that you have the following things:

1. lookup values
2. a commandbutton
3. a copy made of 1. triggered by 2.
4. a formula

problems:
A. the formula has to be put in the next columns after C
B. you want to calculate some totals
C. you want to put 3. after it is altered, somewhere

for A, you might be looking for the range.PasteSpecial command.
for B, take a look at the worksheet_calculate() function.

can you maybe give some more detailed information?

P.S. take a look at Colo's html maker if you want to put your sheet on the board. It is on the left-bottom of this page.