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
Bookmarks