Forum Discussion
Automatically update a list of data from one workbook to another
I have two worksheets, one is the source and the second one is the destination. In the source workbook I have a list of project names. The project names are listed in column A. Adjacent to column A, ...
Hi elianaelia
You can add a custom column
e.g
if [SourceEPRO]=[DestinationEPRO] then [1-lav] else nullBest Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Where shall I add the custom column? In the source file next to the column A that contains the list of projects? Thanks a lot for your response.
Hi elianaelia
Can you show how do you link the data in the destination table with source file?
Best Regards!
Yolo Zhu
Yes of course. I can sent you the files. How can I PM you
Anonymous