Setup Combined Excel Stock Report

$30-250 USD

Completed

Posted

about 4 years ago

$30-250 USD

Paid on delivery

I am the marketing manager (newly hired) for an industrial manufacturer. The company is 2 separate companies that were recently merged. We currently have 2 separate ERPs and the same components have 2 different part numbers from both companies. I would like to take a stock report (excel) from both companies and generate a single excel file that will combine the available stock from both reports and output a single file with a column for each of teh following: -Part number (there are 2 separate part numbers so a database that connects the 2 would have to be created), -Description (part of this database function) -Total available quantity The 2 major constraints: -One of the reports is converted from a pdf The other report is converted from a Google spreadsheet and strange things happen to the formulas -I want all of this to happen automatically with as little manual work as possible Both reports have been uploaded for reference

Project ID: 24070341

About the project

17 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ([login to view URL]). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this as I may have some questions. Best Regards, Jay

$250 USD in 3 days

5.0

(857 reviews)

9.2

17 freelancers are bidding on average $120 USD for this job

@asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss. Thanks, Asad Khan FixIT Consultancy

$100 USD in 7 days

5.0

(751 reviews)

8.2

@schoudhary1553

Hello, I can help you with your project - Setup Combined Excel Stock Report I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

$160 USD in 4 days

4.9

(544 reviews)

8.4

@P0L

Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD in 3 days

5.0

(497 reviews)

8.0

@mateenbhatti94

Dear sir I will create a macro in excel that will choose the pdf and excel sheet and than merge the document according to document and create a new sheet. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. would you like to discuss the project with me?

$100 USD in 1 day

4.8

(170 reviews)

7.3

@daniyal3214

I can provide you a better solution to this issue. I am a professional Data Analyst, Data Scientist and Data Visualization expert holding years of experience. in Excel, VBA, SQL, Power BI, Tableau and various other tools to perform automation and develop dynamic and automated tools. I will be happy to discuss in detail how I am highly suitable for this project.

$100 USD in 1 day

4.8

(188 reviews)

7.1

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. can do only if we have xlsx data from both ERPs. Please check for that. Willing and looking forward to working with you. Thank you, Regards.

$140 USD in 4 days

5.0

(183 reviews)

6.9

@mtdevil369

Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks

$70 USD in 1 day

4.8

(280 reviews)

6.8

@superseoservice

Dear Hiring Manager, After carefully reading the requirements of the project, I believe that my strong experience and dedication make me a suitable match for this. I have completed some similar projects in the past with 100% satisfaction and result. I am really excited to apply for this project and very hopeful to get a chance to work with you! Thank you.

$140 USD in 7 days

4.9

(22 reviews)

4.6

@hiteshchavadaa

Hi There, I am interested in doing your work. i have read and understand your project description nd also requirements.I have 5 years of experience working in this filed.i can do this task with best quality as you expected. Let's Discuss to start Regards, Hitesh Chavada

$30 USD in 1 day

4.9

(29 reviews)

3.4

@hsh564cf84accd96

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on similar requirement in past. We have right skills to work on this assignment. We will complete the work as per requirement

$120 USD in 7 days

5.0

(2 reviews)

2.5

@vnegi2016

Hi, there! My name is Vikram , just to see that you're looking for an Excel VBA developer. According to your brief Combined Excel Stock. Report. I am Excel VBA expert and can help you in your project , (we can discuss the milestones, I don't require any payment in front).

$140 USD in 3 days

5.0

(11 reviews)

2.0

@ahmadaskar

Hi, Great ... this is a typical job for excel power query the very powerful tool is designed specifically for these situations. if you are ok just ping me and we will see how to automate that merge together. it should not be that difficult but we will know the ins and outs when we delve in Looking forward working with you on this. Congrats on your new position. Regards. Ahmad.

$200 USD in 7 days

5.0

(2 reviews)

2.1

@SSKI1234

sir I checked your two attached file.. it not a hard job. your PDF needs to be converted in to excel. then to be used formulas then it's easy. I am professional data entry stuff experience over 10yrs mostly I love excel. please initiate me to the chat for further discussion. I am ready to start working on your project

$60 USD in 1 day

5.0

(1 review)

0.0

@FaisalBhuri

I read your post very carefully. It's my main skill so I have confidence to complete this on time. I can guarantee quality, satisfaction of this and think more learn. I 'll wait for you.

$100 USD in 1 day

0.0

(0 reviews)

0.0

@Ahmadfaisalaziz

I am a supply chain specialist which use excel in daily job to make automation and report to top management, and i am very familiar with the inventory and how to handle it

$35 USD in 1 day