Embedding an Excel to a master Excel

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.

CHICAGO Daily Report 022519 test.xlsx

Final Output.xlsx

Tips and Tricks

Accepted answers

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

All comments

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

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

No problem...

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

Annotation 2019-02-27 135045.jpg

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_

Thanks.

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

Quick Links

Tags

This months top contributors

Hollingsworth 335