This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am seeking assistance with an Excel Automate script. As this function is relatively new to me, I'm encountering difficulty in constructing a suitable formula. My objective is to retrieve values from the second table, and if they are not found, maintain the values in the first table unchanged. Both tables are dynamic as new data may be added periodically.
Is there a pre-existing Automate script available for this task?
Thank you!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could you show an expected result for what you want the macro do?
Do you mean you want to update the table in data sheet based on the table in sheet1?
thanks, already shared in private message.
Your file link need organization account.
You may upload file in private message.
Hi, here it is: Pipeline.xlsx
The idea is that once the project status and probability columns are inserted for the new projects in Sheet1, they should automatically replace the corresponding fields for the same projects in the data sheet. Is it feasible? Thanks.
Could you share a test file with some dummy data and expected result?
For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community