Update to the GRO Genealogy Spreadsheet

[kevinf2349]

Hello,

I have updated my GRO Excel Spreadsheet with some new (and hopefully useful updates). The new spreadsheet has the following changes:

• The ability to import worksheets from the old GRO spreadsheet.
• The ability to flip the colour scheme.
• The ability to add a tick mark into a cell or range of cells.
• The ability to check for duplicate entries.
• The addition of the new worksheet named "Unsure".
• The ability to move records from "Incorrect" or "Unsure" worksheets.
• A backup facility has been added to allow a backup to either the same workbook, or a different workbook.
• The ability to re-apply formatting to a worksheet.
• The ability to change the date formats on the sheets.
• The ability to recalculate the cost column or add it if it doesn't already exist.
• The ability to sort the data on a sheet into ascending date order.
• The ability to change the right click menu without the need to change code.
• The ability to disable the right click menu and re-enable it. Any changes to the menu items will be picked up when the right click menu is re-enabled.
• The ability to change the options in the dropdown menus without code changes.
• The right click menu has been made into a submenu and is now toward the top of the Excel right click menu.
• The ability to choose the colours used for formatting the sheet rows.
• The ability to change the tab colours for a worksheet.

For a full description of how to use the spreadsheet, please read to documentation which is available from https://abbydalesystems.com/Downloader.php?File=New%20GROCertificate%20User%20Guide.pdf

The spreadsheet is available from https://abbydalesystems.com/Downloader.php?File=GROCertificates.xlsm

You MUST use the Import function to import your existing worksheets into the new spreadsheet.

The data in the old spreadsheet is untouched.

Hope you enjoy the new features.

Kevin