Hi,
I have 2 Excel files Summary and Updated Summary. In Summary file there are A & B columns and in the Updated summary file also there are 2 columns A & B. In Column A of Summary file there is a Unique ID and the status for that ID is there for few ids and the status of few Ids is blank.
In the Updated Summary file also there is a Unique ID column but the Status is the Updated one
My Requirement is that If B2 is empty in Summary Work book it has to pull the Status from the Updated Summary work book and if status is already present in B Column of Summary work book (Ex: B6) then also it has to pull the status from the Updated Summary File and add that text to the existing Text (Ex: Test Text in B6).
For Example in B6 of Summary Workbook there is an existing Text "Test Text" if for that ID in Updated Summary Sheet there is a Status text "New Text" then i want to display in B6 of Summary Workbook "Text Text - New Text".
It can be seperated by a single line space in the same cell or any kind of Special Charecters (Preferably "-" or Next Line in the same cell).
Is this possible to do ?
https://drive.google.com/file/d/0B_8nXiEldUKKdkZVSThSME9sc28/edit?usp=sharing
Need your help regarding this.
I have 2 Excel files Summary and Updated Summary. In Summary file there are A & B columns and in the Updated summary file also there are 2 columns A & B. In Column A of Summary file there is a Unique ID and the status for that ID is there for few ids and the status of few Ids is blank.
In the Updated Summary file also there is a Unique ID column but the Status is the Updated one
My Requirement is that If B2 is empty in Summary Work book it has to pull the Status from the Updated Summary work book and if status is already present in B Column of Summary work book (Ex: B6) then also it has to pull the status from the Updated Summary File and add that text to the existing Text (Ex: Test Text in B6).
For Example in B6 of Summary Workbook there is an existing Text "Test Text" if for that ID in Updated Summary Sheet there is a Status text "New Text" then i want to display in B6 of Summary Workbook "Text Text - New Text".
It can be seperated by a single line space in the same cell or any kind of Special Charecters (Preferably "-" or Next Line in the same cell).
Is this possible to do ?
https://drive.google.com/file/d/0B_8nXiEldUKKdkZVSThSME9sc28/edit?usp=sharing
Need your help regarding this.
