Google Sheets Script. Overwrite Query function on a daily basis when column is filled
$30-250 USD
Completed
Posted over 6 years ago
$30-250 USD
Paid on delivery
Hi, I have a query function in a column that gets a currency exchange value from a date in column A. I would like a script that overwrites the query function in this column and control pastes special values of the data when the query function has been activated.
The reason for this is there are about 40 entries per day in this column. Ive noticed the query function sometimes glitches so i would like it to override with the the value of that cell every day. But not override the rest of the data in the column.
The screenshot is from a test sheet.
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 profile.
Thank you for your time !
John
Proposed Milestones
$30 USD - final deliverable
$30 USD in 3 days
5.0 (8 reviews)
4.2
4.2
3 freelancers are bidding on average $99 USD for this job
Dear,
I have done many scripts/tool with Google Script. Could help you on this request. High quality guarantee !
Regards,
Relevant Skills and Experience
Google App Script / Google Sheet
Proposed Milestones
$100 USD - Finish