Search results

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!!

I can't delete because I want to see the trend from the beginning of a certain month until now

Hello Oldchippy, thank you very much for your answer, I thought this was the appropriate place to write because my question is related to data label. How can Excel add for me data label for the last data automatically when I enter new information and delete the data label from the previous day...

Hello! I'd like that the data label should be updated automatically when I add new data. For example, I entered data for January 9 (highlighted) and I updated the chart, so I'd like the labels are updated too. How can I do that? Here is the example. Thanks a lot for your help!

Thanks a lot Narayank991 and Nick M for your great responses! I completely felt lost and frustated, as Nick M said, because the tax burden chart is very intimidating at first sight and I am not familiar with the basics. You have a great idea, Narayank 991, I will start reading from the earliest...

Dear All: I'd like to ask you the best way to learn charting in Excel. I saw some great posts in Charting section of the website but I feel completely lost, for example the post about creating the tax burden chart with scrollbar. I got dizzy because I don't understand how it was created. Hope...