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

[iainhogg]

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?