Færdiggjort

Excel Automation

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.

Færdigheder: Dataindførsel, Databehandling, Datavidenskab, Excel, Visual Basic

Se mere: We have a pdf document under 20 pages and need to convert to excel with all formatting and images in the background, excel automation net requirements, company need microsoft excel automation, intel visual fortran excel automation, need programmer importtext file excel data base, excel automation using borland, end excel automation aspnet, web export using excel automation work, excel automation export, net export excel automation, excel automation visual basic script, excel automation freelance, excel automation charts xaxis range, sharepoint services export excel automation, excel automation step step

Om arbejdsgiveren:
( 77 bedømmelser ) Marietta, United States

Projekt-ID: #15852496

Tildelt til:

royalcalif

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 : [url removed, login to view] Mere

$30 USD på 1 dag
(44 bedømmelser)
4.9

23 freelancers are bidding on average $150 for this job

MimiFL

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 E Mere

$105 USD på 1 dag
(326 bedømmelser)
6.6
P0L

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 in 3 dage
(217 bedømmelser)
6.8
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, models and macros. Check my reviews. Best regards Habilidades y experiencia Mere

$200 USD in 5 dage
(183 bedømmelser)
6.7
zu02

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 in 3 dage
(27 bedømmelser)
5.6
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. I have read your description and i am confident that i can help you to automate your process Relevant Skills and Experience Mere

$150 USD in 3 dage
(39 bedømmelser)
5.1
mauricemarinus

I propose to solve this using an automation app written in C#. Relevant Skills and Experience 17 years developent 10 years c# Proposed Milestones $90 USD - delivery

$90 USD in 3 dage
(25 bedømmelser)
4.6
$155 USD in 3 dage
(13 bedømmelser)
4.6
abhi742

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 på 1 dag
(8 bedømmelser)
3.4
mohamedkaram93

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 pro Mere

$100 USD in 3 dage
(9 bedømmelser)
3.5
nelumindralal

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 u Mere

$166 USD in 3 dage
(6 bedømmelser)
2.8
haleem0786

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 in 3 dage
(5 bedømmelser)
2.3
$155 USD in 3 dage
(4 bedømmelser)
1.7
jawadrafia

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 Expe Mere

$166 USD in 3 dage
(1 bedømmelse)
0.6
andreaslaos

Your work will be done correctly

$255 USD in 5 dage
(0 bedømmelser)
0.0
$111 USD in 3 dage
(0 bedømmelser)
0.0
$30 USD in 2 dage
(0 bedømmelser)
0.0
zircus

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 in 2 dage
(0 bedømmelser)
0.0
$144 USD in 4 dage
(0 bedømmelser)
0.0
juanchigarin

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 Mere

$155 USD in 3 dage
(0 bedømmelser)
0.0
techsoft886

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 Mere

$30 USD in 3 dage
(0 bedømmelser)
0.0