Google Sheets importrange and query plus project - need google sheets formula GURU

$30-250 USD

Completed

Posted

almost 5 years ago

$30-250 USD

Paid on delivery

I have 2 spreadsheets... 1. Interview Master [login to view URL] 2. Interview Notes... [login to view URL] What I need done... Interview Notes I need to import several columns on both sheets from spreadsheet 'Interview Notes" - Importing instructions are specified in the headers when the headers start with the word 'import' - it will also specify which sheet you are importing from spreadsheet 'interview notes'. Otherwise you should leave the column as - is. Interview Master Sheet - B Hiring - I need to import several columns from different sheets in the same spreadsheet and I need to import several colums from spreadsheet 'Interview Notes" - Set a formula to ONLY IMPORT THE ROWS IF THE COLUMN 'HIRING' in the spreadsheet 'interview notes' Sheet - Boys Schools - is equal to either 'yes' or 'probably'. Importing instructions are specified in the headers when the headers start with the word 'import' - otherwise you should leave the column as - is. Sheet - G Hiring - I need to import several columns from different sheets in the same spreadsheet and I need to import several colums from spreadsheet 'Interview Notes" - Set a formula to ONLY IMPORT THE ROWS IF THE COLUMN 'HIRING' in the spreadsheet 'interview notes' Sheet - Girl Schools - is equal to either 'yes' or 'probably'. Importing instructions are specified in the headers when the headers start with the word 'import' - otherwise you should leave the column as - is. Sheet - B Hired I need to import several columns from different sheets in the same spreadsheet and I need to import several columns from spreadsheet 'Interview Notes" - Set a formula to ONLY IMPORT THE ROWS IF THE COLUMN 'Sent to DOE' in the Sheet - B Hiring is equal to 'yes'. Importing instructions are specified in the headers when the headers start with the word 'import' - otherwise you should leave the column as - is. Sheet - G Hired I need to import several columns from different sheets in the same spreadsheet and I need to import several colums from spreadsheet 'Interview Notes" - Set a formula to ONLY IMPORT THE ROWS IF THE COLUMN 'Sent to DOE' in the Sheet - G Hiring is equal to 'yes'. Importing instructions are specified in the headers when the headers start with the word 'import' - otherwise you should leave the column as - is. Paying $40 Max

Project ID: 20362494

About the project

6 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@MohsanEijaz

I am google sheet and google app script expert, lets discuss and start it. Malik

$100 USD in 2 days

5.0

(83 reviews)

6.3

6 freelancers are bidding on average $156 USD for this job

@Aishwaryakumari

Dear Client, I can do this Job. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and everything. I have worked on the similar projects before, so with my interpersonal skills and experience I would be happy to work for you. Best Wishes, Aishwarya Kumari

$40 USD in 1 day

5.0

(18 reviews)

3.2

@InsIncImp

Please discuss your project with us before you award the contract. Once the details of project are known we can come to an agreement on timing and price. I can discuss the project with you on Google Hangouts, Skype or Phone. (Time Zone EST/EDT) Thank you in advance Wins

$250 USD in 5 days