Filtering and generating new tabs based on Unique values based in column

Dear ,


For understanding this project ,please see the attached workbook's......

The first one "Input "see the tab called final ,

Now ,please open the spreadsheet input 1 and see tab Final 2.......

The only difference between Final and final 2 is that the blank rows (Note it does have value in cell H -But for my purpose any row with value just in H is a blank row and needs to be deleted and new tab needs to be prepared exactly like final 1 ......

Now in final 2,you will see that i fill blank entries in column E as NOT FOUND ,

Now see attached sheet DBC project filter Output sheet ....you will note that based on unique values in column E ,seperate tabs are created -i did use datapig explosion for the purpose but wish that i can have a macro for the purpose ...

Also you will note that the attached macro already has a subroutine defined which generates the final sheet based on content of sheet 1 and sheet 2 .......

(is it possible that you make this macro and call oit from the first macro so that on single click of the first subroutine ,all the filtering and then further tabbing takes place )
Anyways ,just making a mcro for the thread will solve my worry ,since i can then easily call the macro from the first macro myself ,

Thanks in advance ,

Regards ,


Amlan Dutta