$$Excel-Macros$$ Web Query Problem / Need Small Macro

Hi Guys, Find attached a simple web query that is currently being refreshed every minute. For the life of me, I am unable to figure out how to have new refreshed data placed directly below the previous data. In anycase, I realized that this would not solve all my issues. Here is what I am

$$Excel-Macros$$ Re: Format Conversation Question

That's works pefectly Haseeb. Thanks !! On Monday, April 2, 2012 8:17:30 PM UTC-4, Haseeb A wrote: Hi, In a an adjustent cell try to multiply with 24 round by 3 =ROUND(A1*24,3) Change A1 to TOI cell. ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for

$$Excel-Macros$$ Format Conversation Question

Hi, There is probably a very simple solution here, but I am stumped. In this link below, you will see a table that has a field called TOI (abbreviation for time on ice). The number is visually set up as minutes and seconds. When I bring this into excel, I am unable to convert this into

$$Excel-Macros$$ Match in Rows

Hi, Not sure how to do this. Looking for a formula (preferably) or a macro to find a number in a row. Kind of like a loto checker. In this case. - There are 20 columns per row. (A1 to T1) - Numbers are not neccesarily sorted. - There could possibly be the same number showing up multiple

Re: $$Excel-Macros$$ Match in Rows

Bang on PERFECT. Thanks very much Viper for the quick accurate response !! On Feb 3, 12:09 am, The Viper viper@gmail.com wrote: in ab1 =if(countif(a1:t1,aa1)0,countif(a1:t1,aa1),) On Fri, Feb 3, 2012 at 10:30 AM, qcan comeonove...@gmail.com wrote: Hi, Not sure how to do

Re: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Exzcellent guys. Amazing. Thanks. On Jul 28, 8:18 am, XLS S xlst...@gmail.com wrote: Hey Ranjan qcan want if cell contain any 3 Capital letter then color hole cell.but your solution color only first 3 letter ... On Thu, Jul 28, 2011 at 5:32 PM, Rajan_Verma rajanverma1

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

)             Selection.Rows(iEnd) = vTop             Selection.Rows(iStart) = vEnd             iStart = iStart + 1             iEnd = iEnd - 1         Loop         Application.ScreenUpdating = True End Sub On Wed, Jul 27, 2011 at 3:38 AM, qcan comeonove...@gmail.com wrote: Hi, A little different request

$$Excel-Macros$$ Formula or macro to find a word that is all capitlaized

Hi, Can anyone help me with some sort of formula or Macro that would identify any word (minmum 3 letters) that is all in caps. I would like whatever is found to be highlighted in yellow. Thanks. -- -- Some

$$Excel-Macros$$ Re: Arbitrage Formula

$0.00 0.00% BREAKEVEN Total $1,060.00 On May 17, 9:03 am, DILIPandey dilipan...@gmail.com wrote: Hi Qcan, For the better understanding of the group, can you transfer the details in an excel spreadsheet and send the same as an attachment. Thanks, DILIPandey On May 15

$$Excel-Macros$$ Arbitrage Formula

Hi, I am looking for a couple of formulas that can be used to calculate an arbitrage in sports wagering. Example 1. An even split based on a 1000 dollar total wager divded between both sides. - Side 1 odds = +110 - Side 2 odds = +150 I know that one would have to wager $ 543.48 on side 1, in

$$Excel-Macros$$ Run - Copy / Paste - Repeat Macro

Hi, I have this great Monte Carlo Simulation program for blackjack. I am not all that good in VBA, but would like a small macro to run this program, the copy and paste the results to another sheet, then repeat that task again for as many times as I wish. Any takers ? I can forward the

Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro

, ashish koul koul.ash...@gmail.com wrote: see if  it helps On Wed, Apr 6, 2011 at 11:03 PM, RON SMITH comeonove...@gmail.com wrote: Here is the file: On Wed, Apr 6, 2011 at 7:01 AM, qcan comeonove...@gmail.com wrote: Hi, I have this great Monte Carlo Simulation program for blackjack

$$Excel-Macros$$ Need Macro / Web Querry Help

Hi, Hopefully someone here can help me out. - I am looking to import the first 50 records in of this URL http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1picks=1 - Then I want it to somehow go to the next page and do the same for the next 50 records until it encounters the

$$Excel-Macros$$ microsoft windows common controls 2.6.0 (SP6)

Hi Guys, Hopefully spomeone here can help me out, as I am now totally frustrated with this problem. - Purchase new computer - Installed Windows 7 64 bit. - Intsalled both Excel 2003 2007. I have many files that have use macros. I never had a problem running any of them under XP. After debbing

$$Excel-Macros$$ Need Help

Hi Group, I am not very knowledgable with VBA and would like some help solving a tedious problem. - I would like to copy and past each page contained on this URL into 1 spreadsheet (copy/paste 1st 50, then go to line 51 and do the same for the second 50 etc etc..