Thanks a lot Mr. Kenneth,

Firstly apologize for not mentioning the purpose of having this VBA code.

I am a day trader in stock market, I have compiled many indicators into an excel sheet, which helps me in selecting a stock for trading next day. I am checking 350 stocks everyday for which:

1. I have created different sheets for each stocks. for instance; "Microsoft Corp", Coca-Cola Company, Intel Corp, etc etc and so on.

2. I have created a folder name "BhavCopy", in which I download raw data everyday, which comes in .csv format. example; for today file name would be "EQ260711", for tomorrow "EQ270711" and so on.

3. I opened any of my workbook to be updated, I run this VBA on Active cell. Active cell; is the cell in last row in column A in every sheet.

4. This VBA firstly insert row in the last row of the sheet, insert today's date, extracts Open, High, Low, Close and Volume for the sheet name "Microsoft Corp" from "EQ260711" and lastly fill down the upper row which has numerous formulas in current row till the last column of the sheet.

Mr. Kenneth your code works perfectly fine, now for my knowledge could you please tell me why we need two Subs "Test_Updates" & again mine "Updates", I am sure after getting detailed intention, you can minimize this long code.

Thanks again.