Presales Order in Excel

$50-120 USD

Terminado

Publicado

hace alrededor de 9 años

$50-120 USD

Pagado a la entrega

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 del proyecto: 7448030

Información sobre el proyecto

13 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 3 días

4,9

(392 comentarios)

7,3

13 freelancers están ofertando un promedio de $78 USD por este trabajo

@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 en 3 días

4,9

(287 comentarios)

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 en 3 días

4,9

(179 comentarios)

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 en 4 días

4,9

(268 comentarios)

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 en 7 días

4,9

(157 comentarios)

6,5

@expertatwork

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

$64 USD en 2 días

4,8

(242 comentarios)

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 en 3 días

4,8

(16 comentarios)

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 en 3 días

4,9

(8 comentarios)

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 en 3 días

5,0

(9 comentarios)

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 en 3 días

5,0

(4 comentarios)

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 en 5 días