Hi, i will try to explain as clear as i can

Example, i have 2 sheets called [SheetCompanyA, SheetCompanyB] and a 3rd sheet called [SheetSelection]

on the 2 first sheets i have 2 records,

A1=1 A2=2,
B1=ClientA, B2=ClientB,
C1=1000, C2=2000
D1= null, D2= null

(lets say both sheets have the same values in the same cells)

and on the third i have 2 records
A1=1, A2=2,
B1=ClientA, B2=ClientB,
C1=2000, C2=3000
D = Is a Drop List containing the names CompanyA, CompanyB

Now what i need to do is,

when i select a value on the drop list depending on what it is (CompanyA or CompanyB)
it then would see that the corresponding cell on A:x value is and populate the corresponding cell on the corresponding sheet.

A bit of pseudo code just to understand it better, an example of what i want to do if i selected a value from the drop list
on the first line of the SheetSelection Sheet.

IF in [SheetSelection:D1] = CompanyA then populate with value of [SheetSelection:C1] on to [SheetCompanyA:D1]

in this example, its the first row and takes the value to the fist row of the other sheet
but that wont be always the case, that's why i need it to compare the "ID" of the client
which is on column A so it knows where to place the value.

so if i was to fill the droplist with the value CompanyA on the 2nd row it would check the [SheetSelection:A2] value and place the
[SheetSelection:C2] value in the [SheetCompanyA:D2] because of the [SheetSelection:A2] = [SheetCompanyA:A2] rule.

God i hope this is understandable

I thank you for your time in advance.