Google Sheets

$30-250 USD

Ukończony

Opublikowano

ponad 6 lat temu

$30-250 USD

Płatne przy odbiorze

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

Identyfikator projektu: 15961838

Informację o projekcie

23 ofert

Zdalny projekt

Aktywny 6 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@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 w 3 dni

4,9

(307 opinii)

6,7

23 freelancerzy składają oferty o średniej wysokości $133 USD dla tej pracy

@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 w 2 dni

4,9

(475 opinii)

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 w 2 dni

4,9

(286 opinii)

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 w 3 dni

4,9

(115 opinii)

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 w 4 dni

5,0

(7 opinii)

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 w 3 dni

4,8

(64 opinii)

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 w 7 dni

5,0

(25 opinii)

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 w 5 dni

5,0

(28 opinii)

4,4

@sagarsureja3

It may be possible, need to have hand on sheets

$200 USD w 3 dni

5,0

(6 opinii)

3,9

@utkarshkatiyar19

A proposal has not yet been provided

$250 USD w 10 dni

4,8

(12 opinii)

4,1

@hsingla85

$155 USD w 3 dni

5,0

(8 opinii)

3,4

@Denishpatel96

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

$111 USD w 1 dzień

5,0

(4 opinii)

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 w 4 dni

4,9

(16 opinii)

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 w 2 dni

4,8

(6 opinii)

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 w 5 dni

5,0

(1 opinia)

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 w 2 dni

4,0

(10 opinii)

2,4

@wukhan96

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

$100 USD w 3 dni

4,0

(1 opinia)

1,3

@Grawlixsoft

i can do this. inbox me for more discussion

$222 USD w 3 dni

0,0

(0 opinii)

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 w 2 dni