Hello,

i have a sheet containing raw material names, prices and the currency. then i have other sheets in same file named by country. these contain my end products cost formulas (various raw materials, labor, packaging etc) which give me the cost of my end product, from there i calculate my sales price.

in the cost formula there are 5 columns respectively;

Raw Material Name | % of raw material in formula | Raw Material price | Raw Material Currency | Cost in local currency

what i want to happen is that when i enter the info in first column, Raw Material name, that column 3 and 4 also fill out automatically.

currently columns 1,3,4 look like this:

=RMaterial!I20 | =RMaterial!J20 | =RMaterialK20

i have to write these all one by one. if i could have columns 3 and 4 fill out automatically when i fill out column 1 life would be much easier.

how can i achieve this?

many many thanks for your help in advance!