Mightymacros Excel Utilities 4.02
Get fast access to a useful set of improved Excel tools
Features include:
A shortcut organizer where you can store your file and folder paths.
A tool to protect and hide multiple worksheets with a store password facility
A multi-find tool that finds and colours for filtering, multiple items with a single click.
A navigation tool that maintains row and column header position and comes with a line guide for large worksheets.
A multi-lookup tool that can return more than the first match as well as the option to return formats
A multi-header lookup tool that performs multiple lookups with a single click.
A multi-find and replace tool
A multi-filter tool with reverse filtering, that you can save, store and retrieve saved filter criteria
A store and insert text tool to save repetitive typing
A bookmarks tool where you can sort and arrange sheets
A clean and trim text tool
A toll for removing empty rows
A tool to insert rows on changing values for separating data with the format options of row height and colour.
A Show duplicates as well as all repeating values tool.
A text tool for changing case
A cell editing tool where you can insert, move, delete text within cells
A rounding number tool
A tool for compare tables
A variety of date tools
On line help and more...
About the macros in the toolkit:
Navigator macro
Excel Navigator
This is a sheet navigation and guide tool for large spreadsheets where the column headers extend beyond the width of the screen. The add-in assists in maintaining row position whilst enabling rapid navigation across your worksheet to the select column. There are two features that will also help you with rapid column selection, the first is the ability to sort the list of headers and the second is the ability to store lists of unique headers that can be saved within the add-in. The add-in also features a line guide which has two modes, one is 'Dynamic' where the guide will move with cell selection and the second mode is 'Static' where the guide will remain stationary. In the Stationary mode the guide can be adjusted to highlight and focus more cells as you navigate across the sheet. The line-guide colour and thickness can also be adjusted to suit your needs. The add-in also allows you to select and deselect Excel's 'freeze planes' option directly from the add-in menu. New Version 1.02 just released fixes the problem 1.01 had when saving stored lists.
:
Header Lookup macro
Excel Header Lookup
The multi-header lookup is a tool that performs multiple lookups across a worksheet by searching for values specified within a key column range and then matching column headers in the return worksheet to populate cells right across the sheet. As well as specifying the search column where your common values are found you will need to specify the row numbers for the column headers by selecting the search header row and the return header row number.
Since this lookup uses the header row, it is important to make sure that there are no gaps or empty cells in the header row, as this will limit the row range and you may miss out on returning all values.
As a simple solution, you can place any value into a blank header cell to extend the lookup range .
There is an auto-backup function, just in case you select the wrong return sheet. This multi-column look-up is a new and very powerful tool that can save you a lot of time when you require multiple lookups across large worksheets.
Multi-Find macro
Excel Multi Find
The multi-find add-in is a useful and powerful tool for finding text and values within Excel. The add-in can perform multiple searches at a time, and is a faster alternative than the single search option provided by Excel's Find Dialog. The multi-find also provides the necessary tools to refine your search to a selected range or column. If you use vlookups when searching for matches and comparing list items then this tool will save you a lot of time. The tool provides the option to highlight the items it finds. You can then use Excel's filter by colour to display and filter the coloured cells.
Multi-lookup macro
Excel Multi Lookup
This Multilookup add-in will help you to find more than one result associated with the lookup item, where a vlookup function will return only a single result from the first match it finds. The new version performs two types of multi-lookups. A standard lookup that will return all values where the lookup key matches. The second lookup is much faster and will return all matches, but only to the first matching key and not to subsequent duplications of the same key.
Although the add-in may appear to be simple and easy to use, just remember to select an empty column to return your lookup values so you don't overwrite any important data. If unsure of the macro action and how it works, then please save your work before running this macro.
Shortcuts add-in
Excel Shortcuts
The shortcuts add-in helps you to organize your short-cuts by putting them all in one place, and making them accessible from within your Excel worksheet by simply right clicking to open the add-in from the cell short-cut menu.
No longer will you have to switch to the desktop or anywhere else to open up your spreadsheets.
The shortcuts add-in facilitates fast access to your Excel files. With a little thought this add-in will help you to better organize and to sort your file shortcuts into logical groups which you can then arrange according to your own preference.
Protect Sheets macro
Excel Protect Sheets
Manage your Excel security on multiple worksheets with this one stop macro add-in.
Protect and unprotect workbooks and worksheets, manage your password, hide and unhide and make very hidden multiple worksheets with a simple click.
Protecting a workbook file will in general, prevent others from viewing hidden sheets, similarly by making a worksheet very hidden the option to unhide from the sheet tab will appear inactive.
The reverse functionality is also there. The add-in will disclose any hidden sheets within a workbook. The add-in is not designed as failsafe, although it can help with security, be aware that passwords can be broken, so please do not pass on any sensitive information hidden in a password protected workbook.
Multi-Filter macro
Excel Multi Filter
The multi-filter add-in is provides a method for rapid filtering of multiple items. It will save you time, you can multi-select any number of items within the list-box as the filter criteria or you can filter an entire column based on the items contained in the list-box. The add-in also lets you store and retrieve stored lists.
Rounding macro
Excel Rounding Macro
The macro request add-in, comprises add-ins that you have requested. These tools are free and you can make a request to this site to add a tool or set of tools to this add-in. Any suitable request that can be adopted by other users will be considered.
So why not make a request today. Your request may then be included along with the rounding macro.
http://www.mightymacros.tools/index.html
Get fast access to a useful set of improved Excel tools
Features include:
A shortcut organizer where you can store your file and folder paths.
A tool to protect and hide multiple worksheets with a store password facility
A multi-find tool that finds and colours for filtering, multiple items with a single click.
A navigation tool that maintains row and column header position and comes with a line guide for large worksheets.
A multi-lookup tool that can return more than the first match as well as the option to return formats
A multi-header lookup tool that performs multiple lookups with a single click.
A multi-find and replace tool
A multi-filter tool with reverse filtering, that you can save, store and retrieve saved filter criteria
A store and insert text tool to save repetitive typing
A bookmarks tool where you can sort and arrange sheets
A clean and trim text tool
A toll for removing empty rows
A tool to insert rows on changing values for separating data with the format options of row height and colour.
A Show duplicates as well as all repeating values tool.
A text tool for changing case
A cell editing tool where you can insert, move, delete text within cells
A rounding number tool
A tool for compare tables
A variety of date tools
On line help and more...
About the macros in the toolkit:
Navigator macro
Excel Navigator
This is a sheet navigation and guide tool for large spreadsheets where the column headers extend beyond the width of the screen. The add-in assists in maintaining row position whilst enabling rapid navigation across your worksheet to the select column. There are two features that will also help you with rapid column selection, the first is the ability to sort the list of headers and the second is the ability to store lists of unique headers that can be saved within the add-in. The add-in also features a line guide which has two modes, one is 'Dynamic' where the guide will move with cell selection and the second mode is 'Static' where the guide will remain stationary. In the Stationary mode the guide can be adjusted to highlight and focus more cells as you navigate across the sheet. The line-guide colour and thickness can also be adjusted to suit your needs. The add-in also allows you to select and deselect Excel's 'freeze planes' option directly from the add-in menu. New Version 1.02 just released fixes the problem 1.01 had when saving stored lists.
:
Header Lookup macro
Excel Header Lookup
The multi-header lookup is a tool that performs multiple lookups across a worksheet by searching for values specified within a key column range and then matching column headers in the return worksheet to populate cells right across the sheet. As well as specifying the search column where your common values are found you will need to specify the row numbers for the column headers by selecting the search header row and the return header row number.
Since this lookup uses the header row, it is important to make sure that there are no gaps or empty cells in the header row, as this will limit the row range and you may miss out on returning all values.
As a simple solution, you can place any value into a blank header cell to extend the lookup range .
There is an auto-backup function, just in case you select the wrong return sheet. This multi-column look-up is a new and very powerful tool that can save you a lot of time when you require multiple lookups across large worksheets.
Multi-Find macro
Excel Multi Find
The multi-find add-in is a useful and powerful tool for finding text and values within Excel. The add-in can perform multiple searches at a time, and is a faster alternative than the single search option provided by Excel's Find Dialog. The multi-find also provides the necessary tools to refine your search to a selected range or column. If you use vlookups when searching for matches and comparing list items then this tool will save you a lot of time. The tool provides the option to highlight the items it finds. You can then use Excel's filter by colour to display and filter the coloured cells.
Multi-lookup macro
Excel Multi Lookup
This Multilookup add-in will help you to find more than one result associated with the lookup item, where a vlookup function will return only a single result from the first match it finds. The new version performs two types of multi-lookups. A standard lookup that will return all values where the lookup key matches. The second lookup is much faster and will return all matches, but only to the first matching key and not to subsequent duplications of the same key.
Although the add-in may appear to be simple and easy to use, just remember to select an empty column to return your lookup values so you don't overwrite any important data. If unsure of the macro action and how it works, then please save your work before running this macro.
Shortcuts add-in
Excel Shortcuts
The shortcuts add-in helps you to organize your short-cuts by putting them all in one place, and making them accessible from within your Excel worksheet by simply right clicking to open the add-in from the cell short-cut menu.
No longer will you have to switch to the desktop or anywhere else to open up your spreadsheets.
The shortcuts add-in facilitates fast access to your Excel files. With a little thought this add-in will help you to better organize and to sort your file shortcuts into logical groups which you can then arrange according to your own preference.
Protect Sheets macro
Excel Protect Sheets
Manage your Excel security on multiple worksheets with this one stop macro add-in.
Protect and unprotect workbooks and worksheets, manage your password, hide and unhide and make very hidden multiple worksheets with a simple click.
Protecting a workbook file will in general, prevent others from viewing hidden sheets, similarly by making a worksheet very hidden the option to unhide from the sheet tab will appear inactive.
The reverse functionality is also there. The add-in will disclose any hidden sheets within a workbook. The add-in is not designed as failsafe, although it can help with security, be aware that passwords can be broken, so please do not pass on any sensitive information hidden in a password protected workbook.
Multi-Filter macro
Excel Multi Filter
The multi-filter add-in is provides a method for rapid filtering of multiple items. It will save you time, you can multi-select any number of items within the list-box as the filter criteria or you can filter an entire column based on the items contained in the list-box. The add-in also lets you store and retrieve stored lists.
Rounding macro
Excel Rounding Macro
The macro request add-in, comprises add-ins that you have requested. These tools are free and you can make a request to this site to add a tool or set of tools to this add-in. Any suitable request that can be adopted by other users will be considered.
So why not make a request today. Your request may then be included along with the rounding macro.
http://www.mightymacros.tools/index.html
No comments:
Post a Comment