I am new to Excel VBA and Macros. Please help, any help will be appreciated. Here I have attached 3 files. Sample Data contains raw data which need to organize. I just added log in time in right column by formula. Step 01 file contains Agent Name and Log in time filtered.I need to filter by text "Agent Login & Name:". Final Data is what I need. I have to this job manually several times in a day. Can it be done by VBA?? If so how?? what will be the method and code??
Pls note: Agents vary day to day.
Plese help.
Thanks.
Bookmarks