I have a excel file called master name list.xls , it contains 2 fields, UserName and UserGroup.
Everyday my database program will export its data in to a excel file which is a mix of user names and user groups(some times this database program will put users in the wrong group).
I want to match the first user name in the data file with the master name list and if found that row should be copied to to the corresponding group sheet(we have 6 user groups and 400 users)
Any help will be greatly appreciated because Iam doing this manually everyday and its very very time consuming and I dont know any serious coding.
cheers..
Arun
Everyday my database program will export its data in to a excel file which is a mix of user names and user groups(some times this database program will put users in the wrong group).
I want to match the first user name in the data file with the master name list and if found that row should be copied to to the corresponding group sheet(we have 6 user groups and 400 users)
Any help will be greatly appreciated because Iam doing this manually everyday and its very very time consuming and I dont know any serious coding.
cheers..
Arun