Setup Combined Excel Stock Report

$30-250 USD

Завершено

Опублікований

about 4 years ago

$30-250 USD

Оплачується при отриманні

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

ID проекту: 24070341

Про проект

17 пропозицій(-ї)

Дистанційний проект

Активність 4 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@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 за 3 дні(-в)

5,0

(857 відгуки(-ів))

9,2

17 фрілансерів(-и) готові виконати цю роботу у середньому за $120 USD

@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 за 7 дні(-в)

5,0

(751 відгуки(-ів))

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 за 4 дні(-в)

4,9

(544 відгуки(-ів))

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 за 3 дні(-в)

5,0

(497 відгуки(-ів))

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 за 1 день

4,8

(170 відгуки(-ів))

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 за 1 день

4,8

(188 відгуки(-ів))

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 за 4 дні(-в)

5,0

(183 відгуки(-ів))

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 за 1 день

4,8

(280 відгуки(-ів))

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 за 7 дні(-в)

4,9

(22 відгуки(-ів))

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 за 1 день

4,9

(29 відгуки(-ів))

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 за 7 дні(-в)

5,0

(2 відгуки(-ів))

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 за 3 дні(-в)

5,0

(11 відгуки(-ів))

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 за 7 дні(-в)

5,0

(2 відгуки(-ів))

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 за 1 день

5,0

(1 відгук)

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 за 1 день

0,0

(0 відгуки(-ів))

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 за 1 день