Dear Friends,
Please help me with the excel formula / Macro to pull the employee number from my payroll sheet with reference to pay mode as cash salary to my existing excel sheet(separate sheet).
Example attached for ref.
Master for the report as below:
Code Pay Mode
9101748 Bank Transfer WPS
9101749 Bank Transfer WPS
9101750 Bank Transfer WPS
9101751 Bank Transfer WPS
9101752 Cash
9101753 Bank Transfer WPS
9101754 Bank Transfer WPS
9101755 Bank Transfer WPS
9101756 Bank Transfer WPS
9101757 Bank Transfer WPS
9101758 Bank Transfer WPS
9101759 Cash
9101760 Bank Transfer Non WPS
9101761 Cash
9101762 Cash
9101763 Cash
9101764 Bank Transfer Non WPS
9101765 Bank Transfer Non WPS
9101766 Cash
9101767 Bank Transfer Non WPS
9101768 Bank Transfer Non WPS
9101769 Cash
9101770 Bank Transfer WPS
9101771 Cash
9101772 Bank Transfer Non WPS
9101773 Bank Transfer WPS
9101774 Cash
9101775 Cash
9101776 Bank Transfer Non WPS
9101777 Bank Transfer Non WPS
9101778 Cash
9101779 Cash
9101780 Cash
9101781 Cash
9101782 Bank Transfer WPS
9101783 Cash
9101784 Cash
9101785 Cash
Report required as below
S.NO Emp No
1 9101752
2 9101759
3 9101761
4 9101762
5 9101763
6 9101766
7 9101769
8 9101771
9 9101774
10 9101775
11 9101778
12 9101779
13 9101780
14 9101781
15 9101783
16 9101784
17 9101785
Thanks,
Vijayaraghavan
Bookmarks