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

Can we have a sample from your large list of 350 files..

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

Hi Debraj:

As suggested by you, I am enclosing 2 files, original and truncated one (I am trying to upload but dont know if I will succeed). I am eagerly awaiting your further response. A small correction, column C has time values and not column B.