+ Reply to Thread
Results 1 to 1 of 1

Macro to extract data from specific cells in different workbooks.

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Macro to extract data from specific cells in different workbooks.

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1