Hello, I’ve done many similar projects where the task was to match, extract, compare data, clean up duplicate details and rearrange content or to separate info while crossing and filtering data between the two master excel files. I do the projects by using algorithms and keyword. You will be able to add keywords for further content.
I am a financial guru and expert in Excel/VBA/Macro. I have over 30 years of experience and in-depth knowledge of advanced formulas, pivot tables and Visual Basic Application, including dynamic dashboards, screen layouts (UserForms), drop-down boxes, generator reports and charts. Furthermore, I have expertise in financial statements, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments and bank reconciliation. With these skills, I develop financial modules, such as business valuation methods and ratios for investors, which incorporate complex components of business in an easy-to-use and logical manner. I am confident that my combined knowledge, accuracy, and creativity will lead to exceptional results that will exceed your expectations.