Remote Data Mining And Management Job In Data Science And Analytics

Excel macro vba specialist

Find more Data Mining And Management remote jobs posted recently Worldwide

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 months cost spreadsheet & vs. the master excel customer price catalog. UseVBA & macros to automate comparison of customers 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 recuiter
Member since Mar 14, 2020
Khushnuma Khan
from Parana, Brazil

Skills & Expertise Required

Excel VBA Macros Data Analysis 

Candidate shortlisted and hiredHiring open till - Mar 14, 2021

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$25.01

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Program data within excel

I need need data in excel to be programmed to operate after a specific operation occurs

Amazon FBA Wholesale Product Research and Data Collection

Hello! I run an Amazon FBA wholesale business which is highly dependent on consistently finding new products that my business can capitalize on. I need help going though my distributor lists and gathering all relevant products that are a potential bu...read more

GIS Analyst | Store Location Data | Computationally Heavy

We are seeking an analyst with GIS expertise and tools who can help us with an analysis of US grocery store footprints.

This is an optimization problem where we want to find the global maximum of stores that fall within a certain set of cons...read more

Need an expert in Regression

| need an expert interpreting the results in Regression, to do this for 1 day. Connecting it with hypotheses.

Two files have been attached
-The first file Word :
it is about the methodology of the study and the hypotheses
-The s...read more

Microsoft SQL Server and Access Developer needed

I need someone that is proficient in VBA for Access and Excel. The person also must also have experience in writing SQL code and installing SQL Server express edition on a server and make the database visible via odbc connections on clients machine...read more