VBA Help Needed

[paradoksaalinen]

Hi,

I have created a workbook to calculate production costs in order to provide pricing for sales.


On my main computation worksheet, when a size, length and type is entered, total weight and cost price per piece will automatically be tabulated and shown at the bottom. All these are done using various formulas and pivot tables.


Now I need a new worksheet that only show prices for all combination of sizes, lengths and types. The table I need in this worksheet is similar to the below.

SET = A + 2B
[TABLE="width: 1085"]
<tbody>[TR]
[TD="colspan: 2"][/TD]
[TD="colspan: 3"]WEIGHT IN KGS[/TD]
[TD="colspan: 3"]PRICE FOR TYPE 1[/TD]
[TD="colspan: 3"]PRICE FOR TYPE 2[/TD]
[TD="colspan: 3"]PRICE FOR TYPE 3[/TD]
[/TR]
[TR]
[TD]SIZE[/TD]
[TD]LENGTH[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]SET[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]SET[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]SET[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]SET[/TD]
[/TR]
[TR]
[TD] 1/2[/TD]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 1/4[/TD]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 3/4[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
and the list goes on...

I would like VB to simplify things instead of having to repetitively update values manually.


Any advice is appreciated!

 

[patel45]

it's not clear for me, why vba ? why not formulas ?

 

[paradoksaalinen]

it's not clear for me, why vba ? why not formulas ?

Which function are you referring to? Because IF and/or VLOOKUP function would not work unless each combination (of Size, Length & Type) has it's own cell value.

In my main computation worksheet, the value of Size and Length has to be entered in order to view their respective weight and price. The results of the weight and price appear at the same cells so it's generating results based on selection. And Type has to be selected from a drop-down list where each type consists of a separate calculation all together, which is linked to my other worksheets and workbooks.

So for this worksheet, hereby referred to as the "Price List", I need it to display only the weight and prices of each combination.

Hope I sounded clear enough. Please share if you think there is a simpler way for me to work this out. Thanks.

 

[patel45]

I hope someone will understand better, I can not