Find duplicate name + codes

oleh mythtaker672

Excel sheet with over 700 thousand part names & codes. Job was to find parts with same name but multiple codes. Doing the job within Excel took 30+ min. so the macro used MS Access instead to do the job in under 3 minutes. User didn't need to know how to use MS Access, macro does everything. Second picture shows final result

image of username mythtaker672 Flag of India Mumbai, India

Tentang Saya

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

$8 USD/jam

3 ulasan