Posts by naira

    Hi!


    I am looking for help on VBA for automatically copying contents of a row to another worksheet per minute.
    Have seen some codes on the internet but they are all dependent on every time a row's/ cell's contents are updated not on a per minute basis.


    Sample file with example display of the current data from live data feed from monitoring instruments and the worksheet for stored data is attached.
    I would be looking for around 400 rows of data while monitoring a total of around 1000 columns of instrument parameters.


    Thanks.

    Hi!

    1. I was wondering whether it is possible to add one or more straight lines (perhaps a new series?), indicating the current price (or other price levels) to a VOHLC Chart in excel. (As the red line in the sample file attached).
    The value will be the current price of the Instrument and will be carried in a single cell and the cell value changes dynamically.

    2. Also, is it possible to show/ add some name to this indicator line that can be shown in the middle of the chart or on the side as an index value that moves up and down with the indicator line (P in the sample file attached) (This is optional feature request).

    I read somewhere that it is possible to do so with a scatter chart etc. and then change it to a line, but when I try it, I get an error saying that some chart types cannot be mixed with other. I am using both excel 2007 and Excel 2010 but get errors in both.

    Could someone please tell me the procedure step wise and show it in the Sample file is attached?

    Regards,

    Naira


    PS: Question also posted at http://www.excelforum.com/exce…cator-in-vohlc-chart.html

    hi!


    I need to do a Vlookup where the reference field is Now() time in mm:ss format.
    I need the excel file to see the now time in mm:ss format and give me the vlookup result from the array.


    I am attaching 2 files, first is my data file in which i need to do the vlookup while second is the file that continuously updates itself so that you can check whether the result is working in real time.
    Following things may please be noted:
    1. I know how excel sees time in no. and decimal formats, so please don't inform me on that again;
    2. I have been able to get partial result and you can check this when you run both the files together. But my vLookup solution works only till 08:15 of an hour (in mm:ss format) and stops after that. can someone please check what am I missing here? (To check, please reset your system clock to the start of any hour and check till 08:15 mm:ss of that hour).
    3. Would prefer a non-macro solution, but if it isnt possible, then macro can also be advised;
    4. The result of vlookup need not necessarily be in the result format that i have given in my excel file (i.e. instead of the output result being in my data, it can be any other text filed also), but it should work for all the mm:ss results across the 1 hour time frame, reading Now() time in mm:ss format.


    Regards,


    Naira