# dynamic list problem

#### RobShaw

##### Board Regular
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?

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
apologies for the spacing problem previously, how do I paste a pic?

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.

Replies
1
Views
121
Replies
11
Views
546
Replies
21
Views
720
Replies
1
Views
228
Replies
0
Views
358

1,207,111
Messages
6,076,620
Members
446,216
Latest member
BEEALTAIR

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back