Recent content by chronot

Thank you very much for your explanation Luke M! I tried to use only ISNUMBER function within the MATCH function, MATCH(TRUE,ISNUMBER(B6:B$100),0)))) but in some cases I get #N/A. Could you explain me why?

Wonderful, Luke M, infinite thanks for your great help!! Why do you use an INDEX function inside MATCH?

Hello my friends! I have this spreadsheet with two columns. For instance, in cell A13 I have the code 9704.00.00 (10 characters long) but the percentage is in cell B16, it's not in the same row as the code in column A. How can I move the value in cell B16 so it's located in B13 (the same row...

Is it possible, Debraj, to put the chart in a new worksheet only and the button that updates the label in another worksheet? Thank you very much for your help

Hello, SirJB7! What a wonderful work, infinite thanks for all your help! I tried at home and it works flawlessly!! I prefer not to modify the code because this is a weird world for me and I don't have the knowledge to understand what the code means. Don't worry about the last page that has an...

Hi, MarcL! Yesterday I tried to execute the code at home and it worked perfectly (Windows 8, Excel 2013) But now I am trying at work (Windows 7, Excel 2010) and the message "No Web!" appears. :eek:

Hello SirJB7 and Marc L! Now I tried again both codes at home and they worked perfectly. Is it possible to use the same code to get data from another Ambito's page? http://www.ambito.com/economia/mercados/riesgo-pais/info/?id=2 I tried to use the same code and changed the web address and...

Hello SirJB7! I have a question about your code: I use it and it works perfectly, but it doesn't import the first data of each page (the 1st line). Do you know why? I really appreciate all the help, thanks a lot!

Hello MarcL and SirJB7! Thank you very much for all your help! MarcL: how can I execute the code? I press the GO button but a message pops up: "No Web!".

Hello, SirJB7! I really appreciate your answer, infinite thanks!! :) Unfortunately, I can't downgrade to Windows 7 because I already bought the Windows 8 license and the same with Office 2013 365 Home Premium What's the meaning of WEBSERVICE function? Is it a function like SUM, COUNTIF, etc...

Wonderful, amazing SirJB7, thanks a lot, it works!!! :) It took about 5 minutes to end in my computer (Windows 8, Excel 2013, Intel Core i5 3.20 Ghz, 8 Gb ram memory. I have some questions: 1) Why does the file have 3 sheets? 2) What's the meaning of all the code? 3) Is it possible to adapt...

Thank you very much for your reply, SirJB7. Sorry I am new to all this. How can I work with this code?

Good morning! I would like to get Argentina's blue USD historical data from January, 2002 until now. The information is at: http://www.ambito.com/economia/mercados/monedas/dolar/info/?ric=ARSB=&desde=11/01/2002&hasta=16/01/2014 Is it possible to import to Excel all data without visiting...

How can I copy the macro to other workbooks where I have several sheets with charts?

OOOHH Excellent explanation Debraj, that's exactly what I am looking for, wonderful!!!! Thanks a lot!!