Find Jobs
Hire Freelancers

Excel Automation

$30-250 USD

Ολοκληρώθηκε
Αναρτήθηκε πάνω από 6 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
We need a large excel file modified. Please pay attention to the instructions, if you don't understand them upon us contacting you that means that you didn't read them or look at the examples -- we will immediately move to the next freelancer. This is very specific. There is an attached sample file. This is just a preview for understanding. Please take note that we have 18k+ unique model numbers for the products. 1) The file is in Google Sheets, but can be edited in Excel if you prefer. 2) The second sheet with "Services" is a list of services we need to offer with every single model of phone in our inventory. The model of phone is in "Sheet1" column "K". 3) Currently, we have product models that offer a all of the services, or a majority, or a few or none at all. We need this fixed and automated/scripted. We need all existing models in inventory to have any and all missing services from the list added. This obviously needs to be able to support us going forward for when we add new product models, and it automatically outputs the service rows. 4) The only data your work needs to be responsible for is to enter Services name (complete list) to each unique model number. An example of the completed view output is located in the "Sample Complete" sheet for you to view and see the completed outcome. 5) Column "post_title" is where this data is finally brought together and generates the full title from all the relevent columns by utilizing "=L2&" for "&J2&" "&K2" for example. This obviously does not need to be done. Complete Defined: This project is complete once: 1) All the 37+ services are listed for each and every unique product. This is the data that is in column "L". 2) The Brand (Column J) and Model (Column K) fields are entered. 3) Your functionality is automated/scripted to allow for models to be added/modified/deleted at any time and it will provide the required rows with services. If you have any questions, please ask upfront. If it is not in the job description project details it is not binding. All terms must be agreed to prior to start/accepting project and in writing with an edit to the project details.
Ταυτότητα εργασίας: 15852496

Σχετικά με την εργασία

20 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Hi Mr. Employer I would like to discuss little bit more about the task. PM Me. Whether do you need in Google sheets or excel spread sheet? Relevant Skills and Experience Production Overview : [login to view URL] Purchase Order - [login to view URL] Proposed Milestones $30 USD - 1 "Price might be negotiable during discussion. Pm me for more information and sample as well. "
$30 USD σε 1 ημέρα
5,0 (79 αξιολογήσεις)
5,4
5,4
20 freelancers δίνουν μια μέση προσφορά $156 USD για αυτή τη δουλειά
Avatar Χρήστη
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
$200 USD σε 3 ημέρες
4,9 (280 αξιολογήσεις)
7,2
7,2
Avatar Χρήστη
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA/Databases Htos propuestos $200 USD - final delivery
$200 USD σε 5 ημέρες
5,0 (214 αξιολογήσεις)
6,8
6,8
Avatar Χρήστη
Automating a process of generating rows based on input data sheet (list with unique products) and services sheet. Basically each unique product row should appear as many times as listed services. Relevant Skills and Experience Data Processing, Data Automation, Data Manipulation, Excel, Excel VBA, Excel Macros, Visual Basic. I believe i can automate this for you, i've completed hundreds of projects like this one. Proposed Milestones $105 USD - Complete automation as described in project description If possible message me, i have multiple follow up questions to clarify row generation. Thanks, Milan
$105 USD σε 1 ημέρα
5,0 (411 αξιολογήσεις)
6,8
6,8
Avatar Χρήστη
Hi, there I can code your current project via Ms Access software Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones $155 USD - default
$444 USD σε 3 ημέρες
4,7 (31 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
Hi there, I will be happy to help you with that. We can have a Google script for your G spreadsheet that generates the output sheet as you described. The script will take all services that you provide and all products. Then for each product, it will generate a row for each service you offer for that device. The script will be flexible, it can work with any number of services or devices listed in the two input sheets. Basically, it will iterate over each row in the input sheets until it reaches the last rows while getting the list of available services or devices. So you can either edit the number of services or devices without any limitations. The script can be invoked using a custom menu added near the Help menu in the spreadsheet or a custom button. It will work for any person has edit access to the spreadsheet. I believe that your description is super clear and organized. I don't have any questions at the moment. I will be happy to address any of your questions! Sincerely, Mohamed
$100 USD σε 3 ημέρες
5,0 (17 αξιολογήσεις)
4,9
4,9
Avatar Χρήστη
Hi, I went through the description But I need some clarification. Kindly contact me then discuss. I can do a good job for you. Last section, no 2, what did you mean by J and K rows entered and filtered. I can't understand that I am looking forward to hearing from you Thanks Regards Thushara
$166 USD σε 3 ημέρες
5,0 (26 αξιολογήσεις)
4,3
4,3
Avatar Χρήστη
Hi. I have done excel automation work using VBA. Please revert for further discussion. Thanks. Relevant Skills and Experience vba, excel Proposed Milestones $90 USD - Initial $90 USD - Final
$180 USD σε 1 ημέρα
5,0 (9 αξιολογήσεις)
3,8
3,8
Avatar Χρήστη
I can do this. I have good command over MS Excel especially povit table, charts, advance formulas etc. do let me know. thanks
$160 USD σε 3 ημέρες
4,9 (15 αξιολογήσεις)
3,6
3,6
Avatar Χρήστη
Hi there, I am a professional person having 10 years’ experience in Microsoft Office and you can review my profile. By viewing your project, I am offering my services for the project, Regards, Relevant Skills and Experience I am an expert in: 1. Formulas, Graphics, Charts, Pivot Tables and Power Pivot 2. Data analysis tools, Queries and Solver 3. Professional formatting in Excel 4. Any task in excel Proposed Milestones $166 USD - Tasks are clear to me Tasks are clear to me
$166 USD σε 3 ημέρες
4,9 (3 αξιολογήσεις)
2,5
2,5
Avatar Χρήστη
Dear, I will offer you a complete solution for your job. I can add excel macros and external software (for example windows application) to make a special works over the spreadsheets. Relevant Skills and Experience I'm engineer specialized in programming. I'm very resposible person and I could help you when the work is complicated because I have tools to solve the problems and I'm too proactive. Proposed Milestones $155 USD - For a complete solution and professional assistance. Please any question feel free to contact me.
$155 USD σε 3 ημέρες
5,0 (1 αξιολόγηση)
1,1
1,1
Avatar Χρήστη
Dear sir, my name is Sushant Extensive knowledge of HTML5, CSS, PHP, SQL(MySql), Javascript I have worked extensively on a product based company. Relevant Skills and Experience HTML5, CSS, PHP, SQL(MySql), Javascript Proposed Milestones $30 USD - Task Complitation
$30 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Best and fast excel and data entry expert Relevant Skills and Experience Data Entry, Data Processing, Data Science, Excel, Visual Basic Proposed Milestones $111 USD - 100
$111 USD σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Your work will be done correctly
$255 USD σε 5 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I have read your project proposal in its entirety and am 100% confident it is within my skill set. Please contact me to discuss further details. I will automate in Vba for excel only. Thank you and I look forward to hearing from you soon.
$222 USD σε 30 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Marietta, United States
4,9
83
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Απρ 17, 2013

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.