I have set an excel spreadsheet set up to update live data from a URL every 5 minutes. However I am wanting to do try and save a bit of time if possible.
Basically I am monitoring horses bought on a game website. Each horse has the same URL except for the number at the end which goes up in 1 increments. The URL is already set up and when the horse is bought it changes from being blank to having the horses details etc.
At the minute I am able to autofill cells with each uinique URL using fill, then series menu. This is so I dont have to manually enter each URL, as hundreds may be bought each day so it would take too long to do this.
My question is this, am i able to have a automatic series linked to the 'data from web' function in data tab, instead of having to manually adjusting each URL for each individual horse.
Running excel 2002, windows vista (some machines on network are running xp). I have a spreadsheet that I want to be able to edit from all computers on the network so that it shows real time changes on all PC's.
It would be like using google docs, I can't use google docs because my file size is 2.5MB and it is too much for it.
I have designed a live calendar and am trying to highlight selected dates from a column in the calendar. I am able to select single cell in the column and highlight the date in the calendar, But am unable to select multiple dates in the column and highlight multiple dates in the calendar using conditional formatting.
Eg: calender dates are from B5:H9 and multiple dates are in column J10:J13
I'd like to log live update data continuously,i.e. as the data in the cell changes. The problem I'm facing is that the data comes in at uneven intervals-- ranging from 30 to 50 ticks per second. So I can't really use a timer function. I need to use some function which saves the data as the cell value changes. So, for example, if cell A1 gets updated continuously, cell B1 could save the first value of A1 and then cell B2 could save the second value of cell A1-- and so forth.
I want to set up daily charts to monitor various things but Im not sure how best to set up the data in order to do this so it calculates automatically as data is refreshed.
I want to run daily activity data that tells me how many people attend each room per day. the aggregated data would include:
Number of attendances, by room (there are 11 rooms), by day Each attendance grouped by category of patient (up to 25 categories) Each attendance by type of attendance (various groups)
How should I set up the data to show these things in a way that it can be linked to a text file and refreshed daily on opening? the data at the moment is in rows per attendance rather than grouped in any way.
I would like the data to have dates and months etc automatically genetared by the attendance date in order to graph the above indicators, as well as a % atttendance in relation to capacity per room etc
simple excel template that I could try to manipulate my data into so I can get started. The data is generates using a transact SQL query and saved as a text file which I wabt to use for the daily stats.
It is my general understanding that the change event system within Excel vba is fairly particular as to what will fit the mold of a qualifying change event.
For example, changes that the user imparts to the worksheet and other written code are legitament candidates for change events. However copying down data and cells changing their values indirectly rather than directly may not be considered in the Microsoft change event design.
I would like to know 2 things:
1) Does a cell updated by a market data feed mechanism qualify for a change event?
2) Any list of qualifying change event types. It seems that Microsoft does not have this information.
I would like to set up a maintenance register where I would have:
worksheet 1 - a page where staff can choose a location and choose a maintenance issue and hit submit worksheet 2 - after they have hit submit the detail will appear in designated cells in worksheet 2 (a ledger of maintenance issues). so each submit should send the info to a new line in worksheet 2.
I have a basic knowledge of Excel and have used formulas and functions before but not VBA/Macros. Any step by step through setting up the submit button and macro correctly?
I've tried to do Worksheet("Register").Range("A2").Value = Worksheet("Request").Range("A1") after installing a push button but all I get is errors.
Have a dde feed coming in from an external source. I also have a VBA written below to play sound whenever the feed goes below a certain level. When I key in values manually through the function bar the sounds play perfectly. But for some reason it is not reading the DDE feeds as value and it can go past my level without playing the sound.
Code: Option Explicit Private Declare Function sndPlaySound32 Lib "winmm.dll" _ Alias "sndPlaySoundA" (ByVal lpszSoundName _ As String, ByVal uFlags As Long) As Long
I have a cell $A$1 that contains a value, CLIENT or INTERNAL
I also have 2 named ranges, CLIENT or INTERNAL
I would like it (using Data Validation) so that the named range being selected for the list dropdown in cell $C$1 is the value of the cell CLIENT or INTERNAL cell $A$1. Tried indirect but not working with named ranges?
I want to auto update ( refresh ) an external feed containing odds from Pinnacle Sports website, at 30-60 seconds intervals. Here is the link : [URL] .....
I would also want to apply some formulas to other columns in excel, but mainly I would want to know where is the change in odds. For example if Bayern Munchen has the odds 2, and after the refresh the odds dropped at 1.9 I would want to see the difference in another cell.
Each cell in Range("A1:A2000") contains a remark, each phrase or remark is Between 5 & 70 characters all written without line feeds (carriage return,i mean Alt Enter) Just spaces between words. What I would like to do in every cell is to force a line feed (Alt Enter) every 10 characters, and if the 10th character happens to be in the middle of a word I want the line feed to be inserted at the end of this word. Note that the phrases are not necessarily multiples of 10.
I am using the following code to copy the contents of a DDE feed.
Code: Private Sub Worksheet_Calculate() Worksheets("Sheet2").Range("A1").EntireRow.Insert Shift:=xlDown Worksheets("Sheet1").Range("A3:F3").Copy Worksheets("Sheet2").Range("A1:F1").PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub
What I want to do is only copy the row when the columns contain data, as it stands at the moment it's copying blank rows to sheet 2. Is there a way that I can do this?
I would like to use Excel as a measurement device. I have an inexpensive digital microscope that will store sequentially numbered pictures at the click of a button. I am then going to import the most recent picture into Excel and place a grid of transparent rectangles over the picture to serve as my ruler. Would it be possible to continuous update the Excel workbook with the output from the digital microscope?
I have a cell (for example, "A1") which is inserted with a WINROS formula to retrieve some data into my spreadsheet. And it is running live at all time.
Actually, I can't think of any formulas to capture the value from cell "A1" to "B1". Because I do not want the value that I captured into cell "B1" running live. I just want the value "B1" fixed after captured.
I have two tables that pull data from two different SQL tables via an ODBC connection and refresh every 5 minutes. The table headers etc are all identical (it is support call information FYI) but what I want to do is display those tables as one as opposed to two seperate tables - can this be done relatively easily and hopefully without the use of VBA? (Unless anyone is willing to provide the code of course!!)