Search results

i want an excel sheet lying on my desktop name abc to open daily at 9:00 am automatically. regards anup

Dear all I've a vba which is inspired by the solution given by Hui for my other problem earlier discussed in this forum. Function Find_Target(Target, Data, tRange, Optional bRange = 0) As Variant Dim c As Range If bRange = 0 Then bRange = tRange For Each c In Data If c.Value <= Target -...

Dear All link to download excel spreadsheet is http://vll.co.in/wp-content/uploads/2013/03/data-series.xlsx Here column a contains date and column b contains price of a share (in rs.)on that date. I need to see how many times the share price has moved from a certain price by a certain...

Dear all I've got a series of numbers lets say(90, 92, 86, 99, 100, 101, 102, 104, 109, 110, 111, 104, 107 ......120, 125, 130, 140 .......100, 95, 90, 85, 84, ......70) and these numbers are written in excel sheet in column b (the numbers are written in order b1, b2, b3 ...and so on).For...

I've got a black scholes option pricing model in Excel which tells the value of all the Greeks related to the options pricing. If someone knows about options pricing must be knowing about delta, vega, theta gamma etc. This sheet tells me about them. If you just Google it , you'll find lots of...

Hi everybody i have got a series of data which is captured live from exchange. the format of the data is as follows: Open high low close 5,912.60 5,912.60 5,907.25 5,911.65 5,911.95 5,920.80 5,911.95 5,920.70 5,920.80 5,925.00 5,920.80...

Hi Everybody I'm looking for a macro which can sum all the data in a range till a blank cell arrives. For example my data set starts from b2 to b11, and then b15 to b20, now i need to sum at c2 sum(b2:b11) and so on. I need a macro, when i select c2 and press the macro shortcut should...

Dear all I need to know how to copy certain data from an excel spreadsheet, lets say from a1:b10 and paste it on other excel spreadsheet. If i need to paste the same data on other sheet of same spreadsheet i.e. from sheet 1 to sheet 2 then i can do it through a macro but i can't do it for...

https://spreadsheets1.google.com/spreadsheet/pub?hl=en&hl=en&key=0AsicBmCuaAIDdEh6blFKSmczQzRqbl9XU3dkNEN5dUE&single=true&gid=0&output=html Dear All I have pasted the link for my spreadsheet. Here i want a vba for multivariate regression analysis for X1, X2 and Y1. There are lot of colums...

Function Speak(c As Boolean, s As String) If c Then Application.Speech.Speak s Speak = c End Function This function speaks when used for lets say a1>a2, then speak b1, then we write =speak(a1>a2,b1) now my problem is every time a1 will change and becomes greater than a2, it will...

Dear All i need to post an excel spreadsheet here and then i need to ask certain questions regarding that excel sheet. Please tell me how can i add an excel spreadsheet with this post with regards Anup

I've got a problem, i wish you someone could help me on this. I wrote a vba that speaks what i want. Function Speak(c As Boolean, s As String) If c Then Application.Speech.Speak s Speak = c End Function =speak(a1>a2,rept(c1,3)), here it speaks 3 times (cell c1)if a1>a2. Now the...

In excel i have different number from lets say 10 to 200 in random basis from cell a1 to a100. I have a number in b1 which is say 20. Now i want to know if i start from cell a1 to a100 which number comes early (b1- 2, or b1+2) i.e. 18 or 20. Now whichever number comes early i want it at cell c1...