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

Skills: Data Entry, Data Processing, Excel, Google App Engine, Web Scraping

See more: 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

About the Employer:
( 3 reviews ) Houston, United States

Project ID: #15961838

Awarded to:


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 days
(226 Reviews)

25 freelancers are bidding on average $135 for this job


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 More

$75 USD in 2 days
(276 Reviews)

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 days
(221 Reviews)

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 More

$155 USD in 3 days
(101 Reviews)

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+ More

$155 USD in 3 days
(249 Reviews)
$40 USD in 2 days
(158 Reviews)

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 More

$175 USD in 4 days
(5 Reviews)

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 More

$100 USD in 3 days
(57 Reviews)

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 More

$60 USD in 7 days
(22 Reviews)
$100 USD in 1 day
(19 Reviews)

A proposal has not yet been provided

$250 USD in 10 days
(11 Reviews)

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 More

$200 USD in 5 days
(6 Reviews)

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

$111 USD in 1 day
(4 Reviews)

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 More

$50 USD in 2 days
(9 Reviews)

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 days
(5 Reviews)

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 days
(2 Reviews)

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 days
(1 Review)

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

$100 USD in 3 days
(1 Review)

It may be possible, need to have hand on sheets

$200 USD in 3 days
(1 Review)

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 More

$90 USD in 3 days
(1 Review)

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 an More

$100 USD in 2 days
(0 Reviews)