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

iainhogg

New Member
Joined
Sep 7, 2016
Messages
6
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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,129,479
Messages
5,636,575
Members
416,925
Latest member
malamutus

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?

Disable AdBlock

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
Top