Google Sheets
-
Is it possible to record my data in 1 Google sheet and as I input it in it can be recorded onto another sheet automatically, ie - as I enter the scores and profit on 1 sheet it will automatically update my proft on another, is this possible and if so is it easy to set up?
I just need to make life easier for myself by inputting once instead of updating numerous sheets every day. -
@Simon-Bates Yes, have a look at the
IMPORTDATAfunction. The formatting of the webpage will matter, but assuming it's in some kind of table, it should work OK. -
@Adam thanks for this, this is exactly what I need, I'm trying to find ways of saving time for my 'admin' and this will definitely help.
Just one more question, am I able to pull data from the Internet to be added to Google sheets, inputting scores for the day is quite time consuming for my data, can sheets do this for me? -
@Simon-Bates Yes definitely.
There are various ways to do it. You can just reference the cells you want directly, e.g. in the cell in sheet 2, type:
='Sheet 1'!A1This will pull the value of cell A1 on the first sheet into the second sheet.
There are also various functions that will help, such as
QUERY,FILTER,VLOOKUPandARRAYFORMULA, depending on what you're trying to do. -
@Adam is this possible?
