elsuji
08-29-2019, 08:49 AM
I have a excel file whch is havind 2 work sheets (Data & Sheet1)
In sheet1 the following to be updated in merged place from Data
We here by certify that the Batching Plant Model H1J bearing Sl. No. 101 supplied by us to M/s. Sri Nandi Conmix., was calibrated on 04-02-2019 by our Service Engineer Mr. Senthil Kumar P in presence of Mr. Umesh (Partner - M/s. Sri Nandi Conmix), Mr. Sathish (Incharge - M/s. Sri Nandi Conmix) and the calibration details are enclosed herewith. We certify that all the parameters are well within the tolerance limit.
We here by certify that the Batching Plant Model (from Data!B5) bearing Sl. No. (from Data!B6) supplied by us to (from Data!B3)., was calibrated on (from Data!B1) by our Service Engineer Mr.(from Data!B15) in presence of (from Data!B16, C16, D16), (from Data!B17, C17, D17),(from Data!B18, C18, D18),(from Data!B19, C19, D19 ) and the calibration details are enclosed herewith. We certify that all the parameters are well within the tolerance limit.
If (from Data!B16, C16, D16), (from Data!B17, C17, D17), (from Data!B18, C18, D18), (from Data!B19, C19, D19) any of it is blank then it wont update here.
Pls tell me how to write the formula for the above condition.
The sample file is attached for reference
24896
In sheet1 the following to be updated in merged place from Data
We here by certify that the Batching Plant Model H1J bearing Sl. No. 101 supplied by us to M/s. Sri Nandi Conmix., was calibrated on 04-02-2019 by our Service Engineer Mr. Senthil Kumar P in presence of Mr. Umesh (Partner - M/s. Sri Nandi Conmix), Mr. Sathish (Incharge - M/s. Sri Nandi Conmix) and the calibration details are enclosed herewith. We certify that all the parameters are well within the tolerance limit.
We here by certify that the Batching Plant Model (from Data!B5) bearing Sl. No. (from Data!B6) supplied by us to (from Data!B3)., was calibrated on (from Data!B1) by our Service Engineer Mr.(from Data!B15) in presence of (from Data!B16, C16, D16), (from Data!B17, C17, D17),(from Data!B18, C18, D18),(from Data!B19, C19, D19 ) and the calibration details are enclosed herewith. We certify that all the parameters are well within the tolerance limit.
If (from Data!B16, C16, D16), (from Data!B17, C17, D17), (from Data!B18, C18, D18), (from Data!B19, C19, D19) any of it is blank then it wont update here.
Pls tell me how to write the formula for the above condition.
The sample file is attached for reference
24896