I have a variable Y
Y = RANDBETWEEN(2,15)
And a variable X
X = NOW()
I am using the following VBA code to refresh the date; to simulate a real time data flow:
Application.OnTime DateAdd("s", 2, Now), "Calculate_range"...
I am starting a project with excel, access, etc.
I want to know if this is possible through excel:
One main spreadsheet with different sheets having multiple users accessing the file and it updating in real time.
Multiple spreadsheets for each user and each can read from each other...
I currently have an access database that is linked to a another data source and they mirror each other. I have spread sheets that access this information and i was curious if it's possible to have the Access Data source updated/refreshed "Real Time". I normally had to generate the list by...