Hello EXPERTS I have a workbook wherein there are thee sheets (Database, Mapping & Employee Name). In the Database sheet, I pull out the data from the tool and put that data in Database sheet. The mapping sheet consist a list of employee who are basically associated with one group or more than one groups. And in the last sheet Employee Name is the data for which i have to take out data from the Database sheet. So what I want basically is :-
1. Macro to go in the sheet Employee Name and check for the name for which it has to filter the data. 2. After taking the details from the Employee Name sheet it comes to the Mapping sheet and check for the group or groups a employee is associated with. 3. After this macro should come to the Database sheet and filter the data according to group or groups which it has got in the Mapping sheet. 4. After filter it should copy the Total Hours and Actual Hours data from there and paste in the Output sheet. Sorry I cannot give you the actual data, but I am attaching the dummy data for your reference. Thanks in advance Regards, Simran Singh -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Dummy Data.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
