hi
i tried to explain my problem in the excel sheet attached
I would really appreciate any help.
Best
Barkin
keep safe
The Question:
I want to automatically write text "EML" to the calculated addresses.
in my example attached ,
I want to automatically write text "EML" to this cell ( AC9) because AC9 is the calculated address.
the calculation is:
- 1. I will find the first "PROD" text on the same ROW that i want to insert 'EML" ; which is on cell W9
- 2. Then I will find that 'PROD's cell address which is W9 ( column W =23 , row = 9)
- 3 "Then I will add the " Transportation Weeks" value , which is on cell J9 = 6 ( column 10 , row 9 ), and which is inserted by the excel user , to the cell adress I foundabove"
- 4 So , our solution should automatically write EML to the calcultated adress/cell which is AC9 [column29=( 23 + 6 ) and Row=9]
PS : If the PROD cell adress changes or the "" Transportation Weeks"" value changes , the calculated EML address has to change accordingly
I have come to some extend , please see my helper calculations on E9 F9 G9 H9