Good day!
A quick description of the job at hand:
1) we have one Masterfile Google Sheet where all our companies product data is stored
- column a: brand
- column b: product name
- column c: SKU
- column d: color
....
2) we want multiple new Google Sheets per 'brand' that each import data automatically from the Masterfile, dependent on the value in column a 'brand'
3) we want multiple Google Sheet per 'SKU' that each import data automatically from the Masterfile, dependent on the value in column c 'SKU'
These sheets need to continue working if:
- new columns are added in Masterfile
- we use more than one value to lookup (i.e. in 3) where the lookup is based on SKU, we want to be able to import data from the Masterfile in one sheet based on multiple SKUs)
- the value we lookup is not in the first but in the, say, third column
Looking forward to chatting with you and quickly getting to a solution.
Plus, our whole business is organized, we probably have a few more other problems where you could make our live easier.
Your profile:
- expert on Google Sheets
- has build similar Sheets before
- clear communicator
- available on a short notice
- quick turn around
Screening question:
This question simply tests for your attention to detail. When sending your proposal to this job please tell me in the first sentence whats the weather today where you are at. Its blue skies where I am :)
Thanks
About the recuiterMember since Mar 14, 2020 Mehdy Panah
from Kahramanmaras, Turkey