Excel VBA/Macro Database expert to automate manual analysis of Cost/Price Excel spreadsheets & report on, & track changes made. Multiple acquisition cost excel files from multiple vendors must be combined all lists into new excel worksheet. Then compare the cost spreadsheet vs. the previous month's cost spreadsheet & vs. the master excel customer price catalog. UseVBA & macros to automate comparison of customer's product & price catalog vs. acquisition cost files from multiple vendors. Report on - 1. new products (part #'s) listed in my acquisition cost files which are not listed in master customer price file - Mark to be added 2. (part #'s) listed in acquisition cost files which are not listed in master customer price file - Mark to be deleted. 3. items where our acquisition costs have changed (higher or lower than the previous cost files) - Mark to review price changes 4. items where units of issue has changed (higher/lower then previous cost files) - Mark to review units of issue
About the recuiterMember since Mar 14, 2020 Khushnuma Khan from Parana, Brazil