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
24 freelancers are bidding on average $137 for this 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.
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.
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
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