Google Sheets

$30-250 USD

Imekamilika

Imechapishwa

over 6 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa

I run a small trucking company. All my data is tracked on Google Sheets. I have two particular spreadsheets I want to work on for this project - with several more less complicated spreadsheets needing to be done soon. The two spreadsheets are "2018 Broker Info" and "Oilfield Customers." Each of my drivers has a tab on the 2018 Spreadsheet (examples attached). Each time they pick up and deliver a load, the data from that load is entered into the "2018 Broker Info" spreadsheets. I want to be able to put in the Invoice # and or BOL # into "Oilfield Customers" spreadsheet and have it automatically import a range of data (column A-J) from the 2018 Broker Info spreadsheet. So once the data is put in to the 2018 Broker Info spreadsheet, all I have to do to import that data to the Oilfield Customer spreadsheet is to type in the Invoice number or BOL number. As if that is not complicated enough, I want to be able to extract that data from each tab (each driver tab) from the Broker info spreadsheet to the Oilfield Spreadsheet simply by the invoice or BOL #. For example. the 2 David tab. His invoices will be numbered 1DAV, 2DAV, 3DAV etc. The 5 Alex, his invoices will be 1AX, 2AX, and so on. So if I type in Invoice #12345A on the Oilfield spreadsheet I want it to pull that range of data from the 2018 Broker Info regardless of which driver's tab that invoice is came from. I need at least 15 tabs to cover all my drivers. Is that remotely possible? Please let me know. Thanks

Kitambulisho cha mradi: 15961838

Kuhusu mradi

23 mapendekezo

Mradi wa mbali

Inatumika 6 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@TonmoyRoy111

Dear client I understand the scope of work and I can set up a nice and easy spreadsheet for you. Kindly contact me for further details. Roy

$100 USD ndani ya siku 3

4.9

(307 hakiki)

6.7

23 wafanyakazi huru wana zabuni kwa wastani $133 USD kwa kazi hii

@SBITServices

Hello , I have read your project description and understood your requirement. I am an excel Expert and can complete task within time with 100% accuracy. It is possible to do remotely. Relevant Skills and Experience Skills : Excel, Macros,VBA,VB.net, Web scraping, Data entry, Copy typing, Transcription works Proposed Milestones $75 USD - project

$75 USD ndani ya siku 2

4.9

(475 hakiki)

7.5

@P0L

Hello, I’m a Google Sheets 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.

$100 USD ndani ya siku 2

4.9

(286 hakiki)

7.2

@rohitpithisaria

Hello I am an excel and google spreadsheet expert and would like to bid on the project posted by you. I will do as required or if you want, I will create an online portal to suffice your needs. Rgds Relevant Skills and Experience Excel Google spreadsheet PHP developer Proposed Milestones $155 USD - Milestone Please initiate conversation to discuss further.

$155 USD ndani ya siku 3

4.9

(115 hakiki)

6.6

@mmadi

Hello Jay2jay, We have gone through the details you have provided for "Google Sheets " and would be pleased to work on this with you to deliver the results that you have expected Relevant Skills and Experience I have 10+ years of experience in Data Entry, Data Processing, Excel, Google App Engine, Web Scraping I can do this within your budget too $30 - $250 USD Let's have chat so i can explain you in deep. Thank you, Regards, Mmadi, Flowgica Technologies.

$175 USD ndani ya siku 4

5.0

(7 hakiki)

6.0

@vineet370

Hi There, Thanks in advance for the opportunity. I came across your project and would like to work on it. I am a post graduate with a great command over English. Relevant Skills and Experience I have more than 6+ years of experience in data entry, data mining & web research work. I can work for up to 40 hours/week and can start work anytime. I will provide you best quality work. Proposed Milestones $100 USD - Google Sheets

$100 USD ndani ya siku 3

4.8

(64 hakiki)

5.5

@ioanaprof

Dear Sir or Ms. I am John, pleased to meet you. All your requirements are achievable. Relevant Skills and Experience I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. Thank you for your time ! John Proposed Milestones $60 USD - Final deliverable

$60 USD ndani ya siku 7

5.0

(25 hakiki)

5.0

@nelumindralal

Hello How about if you use one single userform for all of your drivers, so whenever they can select their ID and type inv no and all data and save. then all the data will collect 2 master sheet msg me Relevant Skills and Experience Excel, Google Spreadsheet, VBA, MAcro Proposed Milestones $200 USD - once done and satisfied with the solution

$200 USD ndani ya siku 5

5.0

(28 hakiki)

4.4

@sagarsureja3

It may be possible, need to have hand on sheets

$200 USD ndani ya siku 3

5.0

(6 hakiki)

3.9

@utkarshkatiyar19

A proposal has not yet been provided

$250 USD ndani ya siku 10

4.8

(12 hakiki)

4.1

@hsingla85

$155 USD ndani ya siku 3

5.0

(8 hakiki)

3.4

@Denishpatel96

I can make sheet complete fields as you enter invoice number.

$111 USD ndani ya siku 1

5.0

(4 hakiki)

3.5

@haleem0786

I can do this. please review my profile. I have good command over MS Excel especially povit table, charts, advance formulas etc and Google sheet as well.

$200 USD ndani ya siku 4

4.9

(16 hakiki)

3.6

@ChanakyaNaag

Hello! I have 2 years of experience in handling excel sheets through automation. worked on more than 40 web scraping projects built 7 automated web scraping tools kindly ping me for further details on the project

$100 USD ndani ya siku 2

4.8

(6 hakiki)

3.1

@Amitkumar1806

Dear client, Thank you for allowing me to post bid on your project. Description of project----Google Sheets Iam ready to start now....i can provide you Great Quality and 100% Complete work Relevant Skills and Experience • Word press , Laravel, Angular.js, Ajax • PHP7,Cake PHP • Code igniter, PhpmyAdmin • MySQL, jQuery, • JavaScript, HTML5, CSS3 • Woo commerce, Proposed Milestones $211 USD - After client discussion

$211 USD ndani ya siku 5

5.0

(1 hakiki)

1.9

@Sundaram87

Hi I'm an expert in Excel using formula.I understood your requirements. It's possible to bring range of data from one sheet to another provided the invoice # or BOL # in both the sheets matches. Relevant Skills and Experience Excel, data cleansing, data analysis Proposed Milestones $50 USD - After completion

$50 USD ndani ya siku 2

4.0

(10 hakiki)

2.4

@wukhan96

I can get it done efficiently and on time! Stay tuned, I'm still working on this proposal.

$100 USD ndani ya siku 3

4.0

(1 hakiki)

1.3

@Grawlixsoft

i can do this. inbox me for more discussion

$222 USD ndani ya siku 3

0.0

(0 hakiki)

0.0

@danielcorner

What you're asking for sounds like a series of nested INDEX(MATCH()) functions for looking up ranges in which to look up sub-ranges. If it's not possible through functions then VBA is more flexible. Relevant Skills and Experience Excel expert with VBA experience -- given the actual files and with your clear instructions I'll be able to quickly test whether Excel functions are adequate for the task. Proposed Milestones $80 USD - Task completion, functioning lookups $20 USD - Confirmation of desired function and any additional automation (buttons/macros, conditional formats)

$100 USD ndani ya siku 2