Embedding an Excel to a master Excel

[roham]

Hi

  How can I embed a Test Excel into a Master Excel and replacing the cells value in master with the test value but still keep the cells with no values in Master Excel. Considering both test and master excel are almost the same.

In my example I need to replace the final output(Test Excel) values into the daily report(Master Excel) based on the Planned Cell ID and still keep the cells which doesn't have any values in Master.

[Aguisande]

Hi @roham 

In which worksheet is the information you want to send to the Master file?

[roham]

Hi,My Bad I forgot to share the Worksheet name. "PSAP Report"

[Aguisande]

No problem...

I looks like you need to Join the PSAP Report with the Master by [Planned Cell Id]

This will give you three ouputs:

- L: All Reords from Input L that are NOT in the other file

- J: All records that are present in both file

- R All Records from Input R that are NOT in the other file

To get all records you want to keep, just UNION the J output with the Input corresponding to the file you want to keep.

Hope this helps.

Best,

_AG_

[roham]

Thanks.

[Aguisande · Accepted solution]

Hi @roham 

Did the post solved your problem?

If so, please mark it as a solution, so other users can find it and use it to solve their issues too.

If not, let me know and we'll figure it out.

Thanks