Search results

Hi Narayank991, Yes, you are right, the result for the first part will be repeated for all the other 4 parts. Will you please give the link for "xls" file as I am using excel 2003. Thanks Pucha

Hi everybody, Friends I would like to know how the time division formula used to divide time in excel. Like the time from 6.00 am to 6.00 pm diving it into 5 equal time period. Example 06:24:02 hrs to 19:01:21 hrs is equal to 02:31:28 hrs each if divided by 5times. This is one part...

Hello, SirJB7 Sorry I couldn't reply as I was out of station. I have downloaded the two files. I opened both files and linked (master file) with my software. But no change of data found in the second file. When master file is open it showing target error! "Updated cells copied with date...

Hello SirBJ7, I am using excel 2003 version. Will you please upload in the same version & tell me the procedure please. Thanks Regards pucha

Hello SirBJ7, I am using excel 2003 version. Will please upload in the same version & tell the procedure please. Thanks Regards pucha

Hi SirJB7 Well, from my trading software there is live data export system. The stock live data s are directly open in a excel file. From these excel file I want to collect the above cells range to another workbook to plot a live stock chart. Hope you got it. As there is no last traded...

Yes SirJB7, For what I understood you're going to "obtain" the data from another source, so there are 2 posibilities: a) you're going to copy and paste the whole range D4:I4 ----------- I want the part "a" only. It will copy automatically these range every time when any one or both the...

Hi SirJB7, Due to my bad English I couldn't explain it correctly. I have Six columns. Here values for "Open" & "Close" column will remain same as for the day trading. Only "Last Traded Price, High, Low & volume" will be changing. I want when the "Last traded price" trigger/change, the...

Hello Debraj here is the sample xls http://www.2shared.com/document/LqP7RCDk/sample.html Thanks pucha

hello friends, May I get some help!!! Thanks pucha

Hi everybody, I want to copy data(values only) from the cells which are updating regularly from a source into another workbook. These are stock values. I already got help on this issue before on this forum "http://chandoo.org/forums/topic/auto-refresh-stock-value-copied-to-next-row" But...

Thanks Deb, Its working very nice. Now its running with system time. And in the VBA code I put 1 for each second refreshment. Thanks "Bhalo Theko" Regards Pucha

Hi Deb, Thanks for solving and the attached sheet. But its showing one minute ahead the system time after refresh. Will you please help me to write the macro for refreshing each minute. Thanks Pucha

Hi Any solution to this problem. VBA code etc. Or simply highlighting the time column as per system time. Thanks pucha

Hi, I want to match the current time now() function in a cell with the range of time in Column A and highlighting by conditional formatting. 05:30 AM 05:31 AM 05:32 AM 05:33 AM 05:34 AM 05:35 AM 05:36 AM 05:37 AM 05:38 AM 05:39 AM 05:40 AM 05:41 AM 05:42 AM -------- --------...

Hi Luke M Sorry for late reply. Thank you once again for solving this problem. I am really great full to you. It works like the way I needed. With regards

Hi Luke M Sorry for late reply. Thank you once again for solving this problem. I am really great full to you. It works like the way I needed. With regards

Hi I am importing the data (Stock) in this manner, (A1 to A4) & (B1 to B4). I am using Excel 2003. I am using auto refresh for one minute. A1 | Feb 24, 10:35 A2 | 28889.00 243.00 (0.85%) A3 | Volume A4 | 40181 B1 | Low B2 | High B3 | 28723 B4 | 28944 Firstly, I would like these...

Hello Luke M, Request for one more help from you. I import the data(Stock)in this manner, (A1 to A4) & (B1 to B4). I am using Excel 2003. Feb 24, 10:35 Low 28889.00 243.00 (0.85%) High Volume 28723 40181 28944 Firstly, I would like these...

Brilliant! Thank you Luke M.

I have the stock value which gets auto refresh every minute. I want to copy the stock value changed every minute to next row automatically, i.e. every time stock value changes it will go to next row along with the time in another cell, so that I can make a chart out of it. Is there any formula...