How to fill a table using 2x input parameters in the existing spreadsheet

[pharley]

I'm not sure about terminology and don't know if the solution to my problem is impossible or simple or somewhere in between. I have a spreadsheet which generates a freight price for shipping goods based on 2 parameters, a postcode and the weight of goods. It uses several worksheets and compares the costs of several freight companies to generate the final best answer.

I want to be able to generate a reference table of freight prices for a range of postcodes and different shipping weights. The postcodes would be across the columns and weight ranges down the rows. For each cell in the table, the macro takes the corresponding postcode and weight, inputs them into the spreadsheet, generates the best freight price for those 2 parameters and then places the answer generated back in the cell of the table. The macro then goes to the next cell in the table, and does the same until the whole table is full.

Is this clear? Can this be done? If it can it would save me about a year of my life doing it manually. Thanks for your help.

[AYData]

Give us a sample representation of what your after.

[AYData]

See attachment

[pharley]

Thank you for the reply but that's not my problem. My table is empty. I want to fill it with values that I compute using my spreadsheet calculator.

I want to run a series of hundreds of separate computations using combinations of postcode and weight and record each of the results in a table.

Can this be done?

[pharley]

Here is an example of what I need to do. I need to fill the table shown. I need a macro that will place each of he postcodes and weights into the input cells generate the output and them place that output in the relevant cell of the table and then go to the next cell and do the next clculation and so on until the table is full. Any ideas?