Results 1 to 4 of 4

Fetch specific range lying between two cell values.

Threaded View

  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    45

    Fetch specific range lying between two cell values.

    Hi:

    In my folder, there are about 350 files with similar structure but varying rows ranging from 300 to 400. In all the files, Column B has TIME values in the format hh:mm:ss, for example, 10:01:00. In the address bar, the time values appear as 10:01:00 AM, 15:11:00 PM, etc. I want to fetch all the rows between two values 15:11:00 and 15:30:00 and save this data as a new file with original file name but adding a suffix 1. For example, if the original (big) file is WorkbookA.xls, then the newly created file will be WorkbookA1.xls. File format is xls. I have tried to do this by Macro Recorder but could not. Can someone help me with a macro for this task?
    PS: All files have columns A:H
    Last edited by GDM69; 11-22-2014 at 01:04 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combine two cell values to pull from specific Named Range
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2014, 06:08 PM
  2. Replace specific values in a range with cell value in the same row
    By HughManatee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-14-2013, 06:39 AM
  3. Replies: 1
    Last Post: 07-24-2013, 05:18 AM
  4. [SOLVED] Return specific values based on the range in another cell
    By AndrewBondarchuk in forum Excel General
    Replies: 3
    Last Post: 11-28-2012, 12:34 PM
  5. Replies: 2
    Last Post: 11-21-2012, 05:59 AM

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