# Loop through list of inputs to two cells, calculate workbook and record output to next line of output sheet

#### iainhogg

##### New Member
I have two list of inputs one column for postcodes (=input!A1) and one column for quantities (=input!B1). I want to take the first postcode, enter it into a specific cell (START HERE'!\$E\$11),then enter the first quantity into a specific cell (=SITE COMPOSITION'!\$D\$33), calculate the workbook and record the result from a specific cell on another sheet(=AV_IRR SUMMARY'!\$F\$46) on the next blank row of the output sheet, recording the value of that cell in (=OUTPUT!A1), the postcode (=OUTPUT!B1)and the quantity (=OUTPUT!C1). Then repeat for each quantity recording output in the next blank row of the output sheet, once the last quantity in the list is reached move onto the next postcode and cycle through all quantities until completed for the last postcode. This should create a three column list of Postcode, Quantity and Values on the output sheet.

I have tried to create vba to perform the task above but haven't been able to get each part to work. Is anyone able to help?

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Replies
1
Views
89
Replies
0
Views
93
Replies
2
Views
434
Replies
0
Views
85
Replies
0
Views
54

1,129,493
Messages
5,636,639
Members
416,932
Latest member
mm07

### 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.

### Which adblocker are you using?

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

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