Forum Discussion
Solved
Updating specific columns
I am creating a tracker that will continuously update information, such as permit status, issued date etc. It will be a master list with some manually entered information in each row. The master li...
Hi Kazzi , Please try these
- Use Power Query to import and clean new data from the system into a Data Source Tab.
- Merge the "Master List" and new data using a left join on Permit Number.
- Update specific columns while preserving manually entered rows.
- Refresh Power Query when new data is added to automatically update the Master List.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Apply the Joine (Combine table) over your manuly entered table and update tdable.
Apply the Joine (Combine table) over your manuly entered table and update tdable.