problem with retrieving value

[HeHeHaHa]

Hi Mod pleease dont remove this thread as I cant reply using PC. the reply i made in previous thread using handphone and typing long code isnt that convinient


I need help with my code. Bear with me if it is hard to understand my problem.

Basically I have a list of file i want to open. In side the file it contains

problem 1.jpg

The file name is Buoy1_2014110106000, The Row value is the from filename's date 2014 (Year) 11(Month) 01(Date) 01000(Hour) up to 7 days of value on hourly basis

So I need to read a combination of row value and column value into my excel spreadsheet where it looks like this

problem2.png

My row column is the Entire Month in this case october on 3 hours step.

I want to read the +24 hours, +48 Hours. of the corresponding row value of my excelspreadsheet (second pic)

Eg. My excel row value is 20141001030000, i want it to read the file which is the exact day, Buoy1_20141001xxxxx, and copy the 24Hours value ahead of excel row value, in this case 2014100203000. with the corresponding column (waveheight) and so on


This is How I open the list of file which i previously tested it works fine.

Please Login or Register  to view this content.

And this i believe is my problem, the macro to trace the value

Please Login or Register  to view this content.

What i think I did in this macro was was, I open up a series of file and I compare the filename with my row value, if it match then i proceed to get the value by matching my row value eg 2014100103000 at cell ( i , 1) and make it ( i + 7, 1) value of (20141002 for the +24hour forecast. so I look for the corresponding value in the list of file i open and read it to my spreadsheet. But nothing come out. May I know what is the problem on the macro? Thanks or can just suggest a far more simplier macro for looking up the value that i want thanks

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic