Google Sheets

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

Evner: Dataindførsel, Databehandling, Excel, Google App Engine, Web Skrabning

Se mere: google spreadsheet >', google sheets login, google spreadsheets >\, spreadsheet templates, google sheets download, spreadsheet download, how to create a google docs spreadsheet, google sheets templates, google sheets online, google sheets how to, google sheets help, google sheets desktop, google sheets api, google sheets and, need programmer for google sheets, looking for a developer working with google sheets, i am looking for someone to write a google apps script in google sheets, hire data entry freelance google sheets, google spreadsheet data entry 2, google spreadsheet data entry -- 2

Om arbejdsgiveren:
( 5 bedømmelser ) Houston, United States

Projekt ID: #15961838

Tildelt til:


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

24 freelancere byder i gennemsnit $137 på dette job


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 in 2 dage
(277 bedømmelser)

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 Sk Flere

$75 USD in 2 dage
(407 bedømmelser)
$40 USD in 2 dage
(194 bedømmelser)

Hello Sir, I have 5+ member team i am done this type job last time with good result so plz give me one chance so i am done this job with good [login to view URL] Regards Relevant Skills and Experience Hello Sir, I have 5+ Flere

$155 USD in 3 dage
(274 bedømmelser)

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 Flere

$155 USD in 3 dage
(112 bedømmelser)

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 hav Flere

$175 USD in 4 dage
(7 bedømmelser)

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+ yea Flere

$100 USD in 3 dage
(62 bedømmelser)

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 p Flere

$60 USD in 7 dage
(24 bedømmelser)
$100 USD på 1 dag
(34 bedømmelser)

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 Flere

$200 USD in 5 dage
(23 bedømmelser)

A proposal has not yet been provided

$250 USD in 10 dage
(12 bedømmelser)

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 in 4 dage
(14 bedømmelser)

It may be possible, need to have hand on sheets

$200 USD in 3 dage
(5 bedømmelser)

Available Immediately | Google spreadsheet expert | Business Understanding | Logistics Business Expert | MS Excel Relevant Skills and Experience Google Spreadsheet | MS Excel Proposed Milestones $155 USD - file

$155 USD in 3 dage
(6 bedømmelser)

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

$111 USD på 1 dag
(4 bedømmelser)

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 in 2 dage
(4 bedømmelser)

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

$50 USD in 2 dage
(10 bedømmelser)

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 Experi Flere

$211 USD in 5 dage
(1 bedømmelse)

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

$100 USD in 3 dage
(1 bedømmelse)

I can create and deliver the project as per the information. I am a skilled, expert designer. I'm very excited to assist you in making a successful project. Relevant Skills and Experience Please feel free to contact m Flere

$90 USD in 3 dage
(1 bedømmelse)