![]() ![]() ![]() Step2 didn't load if the add-on was run from a file with one sheet with hidden columns. Added only up to 10 files from Shared Drive. Pick the scenario you need, and you'll be able to start or edit it. The scenarios menu changed a bit: instead of 2 separate menus to 'Run' and 'View & manage', you will see a list of all saved scenarios under the corresponding menu item. The width of the status column now expands automatically to fit its contents. Auto select the entire range by clicking the gray rectangle between column and row headers. Since you can add spreadsheets to merge from Drive, we made it possible to start the add-on even if there's one sheet in the file. Scenarios didn't work if the second spreadsheet used in the scenarios was removed from Drive. Running scenarios twice in a row simply duplicated the master sheet.ģ. When you changed the lookup sheet in the scenario, it still used the sheet that was saved in the scenario initially.Ģ. The 'Create a new spreadsheet' option updated the main table with the result instead.ġ. Significant performance improvements in processing large amounts of data. The add-on couldn't paste data into the file without a set time zone. ![]() Didn't match dates between the files with different time zones. Couldn't locate spreadsheets in Drive if your search name started with an apostrophe. Didn't match records due to the different space symbols: regular, non-breaking, narrow. If the last column in your main sheet had Data validation rules, they used to be applied to the newly inserted columns from the lookup sheet. If you chose to back up the sheet & clear fill colors in the updated columns, the add-on cleared colors first and created a backup sheet without them. The limit for total cells in a spreadsheet is expanded to 10 million cells. If your lookup sheet has notes, the add-on pulls them along with the values into corresponding cells. It's also now possible to look for the files in the folder with Starred items of your Drive. You can now merge multiple lookup sheets with your main sheet in one go. If there are several matching rows for the same key value, the add-on will not only update the first record but also add those extra matching rows right afterward or at the end of the entire table. Visit our official website to learn more: We build add-ons that help you make the most of Google Workspace. Merge Sheets is a proud member of the Ablebits product family. If you have any questions about the add-on, please post them here: All payments are secure and include an unconditional 30-day money-back guarantee. Use Merge Sheets whenever you need to merge two or more tables and draw the latest changes to the main one.įully functional 30-day trial period. Whatever options you choose, you will be able to save them into scenarios and reuse swiftly later. The tool quickly matches key columns and finds all the necessary updates, no vlookup formulas needed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |