I have been searching this for many days but could not find out the exact solution for my problem. Description about what I want -
I've created a simple master sheet where all the records are entered in daily basis. Column A - Serial No., Column B - Client Code, Column C - Client Type, Column D - Age.
S.N. Client Code Client Type Date
155 N-13-07-16-155 New 2013-07-16
156 N-13-07-16-156 New 2013-07-16
157 O-13-07-16-157 Old 2013-07-16
158 N-13-07-16-158 New 2013-07-16
159 N-13-07-16-159 New 2013-07-16
160 O-13-07-17-160 Old 2013-07-17
(This is the sample which you can find on the attached workbook.)
I want the the data from my Master sheet to be copied New Clients only in "New Clients sheet" and Old clients only in "Old Clients sheet" automatically when I enter data in the master sheet.
Can any one help me. I'll try to clarify the my question if needed.
Thank you in advance.
Client Code.xlsx
Bookmarks