Search results

Hi guys. I have with assistance from you experts learnt a code that keeps track of the development of a stock price on a daily basis. The problem is that the code becomes useless when I forget to update the sheet one day. Can you please take a look and explain if I can make a code that skips...

Nice :) Thank you very much! Is it possible to autmomate this even further? Let say the date entered is 10 days after last non-blank cell. Is there an alternative to pound the radio button 10 times ?

Hi again. Is it possible to alter the code so that values are copied if dates are matching regardless of the first blank cell? For instance if the date is not the first blank cell? Thanks.

Great! Thank you :)

Thanks. Here is the file.

Hi. I have a web query which is updating stock prices daily (sheet 2). I have an IF formula in sheet 1 which retrieves the daily quote if there is a match on the current date. The problem is that I have to copy/paste values each night to prevent the formula to mess up yesterdays quotes. Is there...

Thank you. Tried the SUBSTITUTE(A1,CHAR(160),"") It worked after I multiplied all cells with 1.

Hi. I have tried both the TRIM and the SUBSTITUTE formula but the spaces won't go away in row G. Please help.

Thank you so much guys! :) I am very grateful! I understand that I need to work on my VBA skills. Are there any good tutorials out there you know about?

I am sorry. I think I made myself a bit unclear and I need to go further into details. The data is recordings from the Spanish football leauge for the 5 last years: Column A: Leauge name (SP1) Column B: Date Column C: Home Team Column D: Away Team Column E: Goals by home team Column F: Goals...

Hi. I have a worksheet with values from A1:K1901. Lets call it Worksheet1 The critical values are in the K column. I want to copy all the rows to Worksheet2 if a text criteria is met in the K column. I am not familiar with macros, so a formula would be much appreciated :)

It is random from 10 - 40. It contains the text "hits" everytime I run the web query.

Hi. I want to take my last question a bit further (history from last session): "Hi. I am using Excel 2010. I have a workbook with a web query. Is it possible to autocopy the first cell that has more than 30 characters to a different sheet? It would help me a lot, because I then could see...

Thanks! You are a genius!

Hi. I am using Excel 2010. I have a workbook with a web query. Is it possible to autocopy the first cell that has more than 30 characters to a different sheet? It would help me a lot, because I then could see if there were any changes from the Website. Example: "Sheet1" Range F1:F238...