Google sheet expert to extract dynamic data
Dibayar semasa penghantaran
I need help extracting data from a google spreadsheet on a daily basis.
We have 4 tabs with sales data that changes daily.
The sales data from the 4 tabs are presented in a summary tab.
The summary tab shows the total sales, and average price, percentage occupancy.
As sales change each day the figures changes.
We would like to create another tab that extracts the data from the summary tab on a daily basis and presents it in a graph that expands over time in order to be able to track changes in price occupancy and sale prices. The challenge we are looking to overcome is how to extract the data daily without the data being overwritten by the changing data.
Maybe presented in google analytics or in google spreadsheets graphs
data in the spreadsheet changes daily, however, I want to store the data produced daily and create a graph showing how the results change over time.
The problem I have is that every time the data changes it changes the data extracted from the previous day
ID Projek: #36222107
20 pekerja bebas membida secara purata $103 untuk pekerjaan ini
Hi There, I have read and understand your requirement and I can create your Google sheet script as per your need. Please ping me so we can discuss the details. Thanks & Regards Dev Brat Rai
HI, I am willing to make you an automated excel workbook that will change the statistics on daily basis and the results would be automatically changed. Thank you
HI i hope you are fine i am new here but i have 2 year experience i do lot of work on it i can do it very well i know what you want so if you want tell me further so i can start my work
Your data shall be captured in another spreadsheet on a predecided interval. The graphs can then be feasible from this historical data. Please share sample of your spreadsheet so that we can start the work immediately