File Rename & Save +Custom Function
Macro to do the following functions: 1. Should able to save a given template after renaming as per input part numbers. 2. Categorize part number based on specified logic Both functions should be triggered with buttons and the custom categorize() function must also be accessible via formula bar. Provide clear instructions on how to use the macro including any limitations.
Computer Engineer with 5 years of Excel/Access/Outlook VBA experience Services: MS Access: • UI interfaces, databases design • Custom database development • Upgrading old databases, database migration etc. • Fix broken access database • Access Macro support, VBA support • Advanced Charts • Upsizing Access to SQL Server, Oracle, PL/SQL and more. • Web-scraping MS Excel: • Excel Analyzers, Dashboards • Excel Financial Models • Advanced Excel VBA Development • Excel Formulas, PivotCharts, Pivot Tables, charts, graphs, reports • Excel Add-ins • Data Mining, Data Imports • Web-scraping Outlook: • Custom survey forms • Email drafting automation using Excel/Access criteria • Saving attachments, moving e-mails to external PSTs without user intervention