Merge Sheets in Google Sheets
Use Merge Sheets to keep your Google Sheets tables up-to-date. The add-on will scan two tables for matches and do a quick vlookup. It will update old records, add missing info, and pull new rows and columns to your main table. Learn more on our website:
https://www.ablebits.com/google-sheet...
Get Merge Sheets at Google Sheets add-ons store:
https://workspace.google.com/marketpl...
00:04 Introduction to Merge Sheets for Google Sheets
00:34 Run the add-on
00:44 Step 1 - Select the main sheet
00:49 Step 2 - Select the lookup sheet
00:54 Step 3 - Select matching columns (key columns to compare)
01:13 Step 4 - Select columns to add or update in the main sheet
01:27 Step 5 - Choose additional options
02:27 Save the steps as a scenario
02:43 Wrap-up
👋 Let's be friends on socials!
LinkedIn: / apps4gs
Facebook: / ablebits
#merge #googlesheets #spreadsheet #ablebits
