Hi
I have 586 files (1 file per day for 586 days) with 24 tabs in each file (one tab for each hour of day) so total 14064 tabs. This is a SCADA output for a pump station hourly data over 586 days. I need to extract the flowrate from each tab in each of the files. All the tabs are identically formatted, the data I need occurs in Cell K29 and K30 of each tab. All the files have the same number of tabs and the tabs are identically named (00, 01, 02, 03 ...up to 23). A sample file is attached. I need to create a summary file with the two data points from each hour for 586 days. I'm pretty handy with excel but not very good with macros. I have looked in this forum and could not find a solution. Any help that keeps me from entering 28128 points manually will be greatly appreciated!
Thanks Guys
Bookmarks