dear friends,
please help me on this matter.
i have 2 sheets, in sheet1 contain the Max value address and a number, in sheet2 a column contain several number and a column for result
i need to do a VBA calculation in sheet2 to the MAX value so the result equal with value in sheet1 using copy special paste add, thank you.
note : there are 2 condition depend on the value on column D in sheet1
please help me on this matter.
i have 2 sheets, in sheet1 contain the Max value address and a number, in sheet2 a column contain several number and a column for result
i need to do a VBA calculation in sheet2 to the MAX value so the result equal with value in sheet1 using copy special paste add, thank you.
note : there are 2 condition depend on the value on column D in sheet1