Presales Order in Excel

$50-120 USD

Завершено

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

about 9 years ago

$50-120 USD

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

basically I have a list of products that are provided by most vendors, when I build the cell quantity of a particular product, I would like to create as many sheets quant are suppliers who own the product. and so on for each product This serivrà I then send a request the quote to each supplier with prodtti that I want and that any vendor can provide. in short there a file that contains all prdotti, divided by sheets then there are many files as there are suppliers (each file contains a list of vendor product that has the same code that is present in the fiel General) Each time that the cell quantity is not empty, we must create many sheets estimates how many suppliers, and these new sheets must contain the entire line of that product if it is contained in the file of the supplier. I hope I was clear

Excel

Software Architecture

Visual Basic

ID проекту: 7448030

Про проект

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

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

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

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

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

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

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

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

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

Доручений:

@prameswara

Hello Sir. Im excel VBA macro And formula Expert. maybe i can help your problem for create a master file for you Sir. please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara

$120 USD за 3 дні(-в)

4,9

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

7,3

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

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards

$100 USD за 3 дні(-в)

4,9

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

7,2

@aarifakhtar

Hi:Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and macro. Please connect with me to discuss more.

$77 USD за 3 дні(-в)

4,9

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

7,1

@shikhamehta

Hello, I am an expert in Excel and have done several spreadsheets that manage the sales/order data in Excel. If I understand the requirement correctly, you need a macro (program in Excel) that will read the product list and based on the quantity it need to generate a file for the supplier. Which I believe you will the send to suppliers. If you could share some sample spreadsheets with some data, it will help me understand the requirement correctly and created a very elegant solution for your purpose. I can assure you of quality work like I have been doing for past several years here. Look forward to hear from you. Thanks and Regards, Shikha (Automyze Consulting)

$94 USD за 4 дні(-в)

4,9

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

7,3

@dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

$90 USD за 7 дні(-в)

4,9

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

6,5

@expertatwork

we can setup an excel macro for yours. please reply.. thank you.

$64 USD за 2 дні(-в)

4,8

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

6,3

@wissamSabry

I am an advanced user with over 10 years of MS Excel experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft Excel problem, formula(s), or task.I am looking forward to help you achieve your Excel goals. and I am ready to start your project

$66 USD за 3 дні(-в)

4,8

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

4,4

@ajaykumar0701

I am working as a manager in Procurement and I also freelance at other timings. I have a good expertise in Excel/VBA. Some of the projects I completed in Excel/VBA are Library management system, HR appraisal system, Business Dashboards, Business Intelligence for an event management company etc. I can create an excel workbook that contains all the functions as you need. Hope you would get in touch with me.

$50 USD за 3 дні(-в)

4,9

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

4,3

@andreibred

Ciao! Io lo posso fare. With 8 year of corporate experience as Business Analyst and Reporting Specialist I am an expert in VBA and excel.

$70 USD за 3 дні(-в)

5,0

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

3,8

@julianaccabral

Hello, As far as I understood, you want to create a main spreadsheet where you can input a product and its quantity, then the spreadsheet will generate a quote request to all the supplier of the product with each supplier details. One spreadsheet quote request for each supplier. I can do this work for you in up to 3 days.

$60 USD за 3 дні(-в)

5,0

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

3,7

@vivirain

Hi, I'm interested in this job. Could you kindly confirm whether my understanding is correct or not: 1. You will have a file with 1 sheet for 1 product 2. You wanna a function that once quantity is entered, it will auto generate pre sales order files that will be sent to suppliers who own the products for quotation. However, I would like to clarify below items with you: 1. Is the presales order template same for all vendors or each vendor has its own template? 2. Is there any criteria that we need to follow while generating files? eg, the supplier should have as many products we want as possible? Looking forward to hearing your back comments. Cheers,

$95 USD за 5 дні(-в)