excels

I want to get the data from ~250 different web pages (they're all formatted the same >> they're pages of data for different stock symbols) into Excel. I currently use Excel 2007's built-in WebQuery tool, but: 1) It takes about 3 minutes for Excel to grab the data from all the pages, and 2)...

Anyone know how to convert Excel's 'ERF' function into a MySQL Function? Any help would be much appreciated. Apologizes in advance if this is a the wrong forum. In a jam and need some help! Thank you!!!

I have some excels that are showing previous versions. Can these be deleted? Also, if I send those excels to another user, can they see the previous versions? I have search for anything explaining these versions but the info is not clear. Thanks in advance, Justin

Hi all I've been trying to use the formula for adding up weekly totals and using Mr Excels formula/example on youtube: https://www.youtube.com/watch?v=ZbEmZErWdvY =SUMIFS($B$2:$B$14,$A$2:$A$14,">="&D2,A2:A14,"<"&D3) I cannot for some reason copy the actual formula down any more then two...

I have a "master" excel that loops through a folder of excels, opens them, runs a variety of macros and then saves and closes them. I have always had some excels that crash the application and I finally narrowed it down to excels that have a circular reference in them. I have disabled alerts and...

Hello everyone, I have something I want to do, but I have no idea where to start, so here is the problem : I have many excel files : On the file a.xls I have this <tbody> Igor 10 20 10 Patrick 30 30 10 Bob 20 20 20 </tbody> On the file b.xls I have this : <tbody> Igor 20 30 40 Bob...