Closed

I need an Excel Expert

I have two lists:

- a bill of material showing with the following columns: product code, drawing no., qty

- a list of product with the following columns: product code, delivery date first lot, qty lot 1, delivery date lot 2, qty lot 2

I need to allocate the product of the second list to the drawings of the first list, showing the latest date of reception of material for each drawing .

Skills: Excel, Data Processing, Visual Basic, Google Spreadsheets, Spreadsheets

About the Client:
( 0 reviews ) Padova, Italy

Project ID: #34823734

48 freelancers are bidding on average €856 for this job

paris2785

Hi, there! My name is Paris, and I was glad to see you are looking for an Excel developer. I will automate your Excel workbook. I plan to use a combination of formulas and VBA (macros). May I have your workbook? I'm a More

€950 EUR in 3 days
(505 Reviews)
8.4
datakillers

Hi,"I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a gre More

€750 EUR in 1 day
(589 Reviews)
8.3
asin1987

Dear Employer, I understand on the basis of the product code you need to pick up the latest date of reception and then allocate that to the drawings of first list. I am an Excel expert and will do a professional job More

€750 EUR in 4 days
(289 Reviews)
8.3
seaanddream

Hi, my name is Selim. I am the Director of ANC, registered in the UK. I read your "I need an Excel Expert" project descriptions carefully before bidding. I got what you need and keen to discuss project details when you More

€750 EUR in 10 days
(315 Reviews)
8.0
(553 Reviews)
8.0
(316 Reviews)
8.2
(333 Reviews)
7.4
prameswara

Hi Sir Im excel VBA macro and formula Expert :) i can help you to build your macro to allocate the product of the second list to the drawings of the first list, please ping me now and im free now Thank you Sincerel More

€750 EUR in 3 days
(428 Reviews)
7.6
aubrey03

I am an Excel, Google sheets, Google scripts and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check my portfolio website here: http:// More

€750 EUR in 2 days
(234 Reviews)
7.0
akritisood94

Hi, I would love to help you to create an excel template. I'm an expert in project management, Excel VBA, complex formulas, dashboard, pivot tables, etc. Recently created an Excel ERP system that includes detailed manp More

€750 EUR in 2 days
(319 Reviews)
7.2
(123 Reviews)
6.7
GopalJp

Hi, You need to send me a sample or example for 1 instances as how you wants the results to show then I will write a VBA code in excel and create an excel tool for the said process. I am an spreadsheet developer with More

€750 EUR in 7 days
(35 Reviews)
6.7
(113 Reviews)
6.4
(103 Reviews)
6.6
(44 Reviews)
6.7
Muhammad6979

Dear sir/madam I am an excel expert. I am chartered accountant with 15 years of professional experience. You can see my profile. Regards Muhammad Ilyas Saeed

€1200 EUR in 7 days
(104 Reviews)
6.2
NIKITALILA

Hi there, I can definitely help you with your excel related issues. We can do a quick zoom meeting to understand your requirements in detail. We are a team of trained  professionals with years if experience in MS ex More

€799 EUR in 3 days
(46 Reviews)
6.3
MartinDudumi

Hi there, I'd like to be considered for your request. I’m a data guy with a strong background developing several excel tools including vba automation and complex formulas and functions applied in excel and I can assu More

€750 EUR in 1 day
(48 Reviews)
6.1
zu02

Hi I can do it via ms Access standalone desktop app. Do you agree? If you agree , I'll code from scratch Access app with a friendly interface. If you need it only in Excel - I can code via it also. But Access app will More

€750 EUR in 7 days
(44 Reviews)
6.1
CanguruWorkana

Yup. I'm the Excel expert you need. I will allocate the product from the second list to the drawings in the first list, showing the last material receipt date for each drawing. This will be done simply and quickly with More

€890 EUR in 2 days
(13 Reviews)
5.7