Courier vise file

[Fasih Ahmed]

Hi All,

I am new user here. i need your help

This is my official file as i attached please help me out.

What i want file content 75 columns. In the columns "AF" name "COURIOR" has Blue Dart, DHL, BSA,
Please suggest how can i prepare courier vise file like filter to Blue dart and copy its respective fields and paste to new sheet,
as same DHL file, BSa file.


Please help

Thanking you.

[boopathiraja]

Hi,

Welcome to the forum,

May be with Pivot table check out the attached file...

[Fasih Ahmed]

Thank you my Dear,

But that not my need. let i clear you that i want to browse this file from my computer "D drive then this will automatic filter to each courier and copy its respective fields and paste to the new workbook and save as in the same path where i had browse this file also save with its respective courier name. Like DHL Courier file, Blue Dart Courier File, BSA Courier File,


Please feel free for any query. hope its clear now.
Please HELP PLEASE.

[Fasih Ahmed]

Thank you my Dear,

But that not my need. let i clear you that i want to browse this file from my computer "D drive then this will automatic filter to each courier and copy its respective fields and paste to the new workbook and save as in the same path where i had browse this file also save with its respective courier name. Like DHL Courier file, Blue Dart Courier File, BSA Courier File,


Please feel free for any query. hope its clear now.
Please HELP PLEASE.