asked on

TT Status Chang

I had this question after viewing Status Change.

Hi Experts,

This Same kind of question like my previous question ...need bit changes ...please help me out.
in attached WB - need to work on between 2 sheets - Import and Master.need to update Master Sheet from sheet import.
Update only when batch number (Column D in both sheets) match and import sheet is not blank values for particular column which needs to update i.e. Master have values and import have values - Update .....Master dont have value and import has it - Update........Master have values but import dont have - no update for that column.

Question - Which column Needs to update ?
Answer - Column H (Standard Wight) - Column K (Remarks) - Column W (TOC Color) - Column Y (Rework/Fresh) - Column AC (Inw No) - Column AD (Inward Date) - Column AE (Inward Status) - Column AF (Transfer No) - Column AG (Status Change Date)

And
Column AH (Status Change Narration) but here need to add data after comma i.e. not to overwrite , just adding text after commas.

Last Column AI (Open/Close)

see Attached columns are highlighted with yellow.

Thanks
--TT-WIP-A.xlsm

ASKER CERTIFIED SOLUTION

Mike in IT

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Naresh Patel

ASKER

Worked but with error as i just want to apply changes only on match .....here i see long list of fresh orders which is not required for this question.anyway i am closing this and contioue with add entry question.

Thanks

Naresh Patel

ASKER

Thanks