Copy data based on IF statement into new worksheet using button co
I want to copy data from a master worksheet to summary worksheet using an If
statement matching the "Project Division" data. If the Admin Mgr changes, I want to put in a blank line. Each cell should also have a border. The data should also be sorted by Location/Region. I am looking to put all of this code into a button on the main menu so that it populates the summary worksheet with current data. Here is the input worksheet outline: First Last Employee Location/Region Position Admin Mgr Project Division "A" "B" "C" "D" "E" "F" "G" Tom L Tom L Oshawa Program Analyst Ted Bundy Divisional Projects Sean T Sean T Whitby Manager Ted Bundy Divisional Projects Wendy J Wendy J Pickering Clerk Tom Jackson Change Mgmt Andy D Andy D Ajax Installer Ted Bundy Divisional Projects Here is the output worksheet outline: Employee Location/Region Position Admin Mgr Project Division "A" "B" "C" "D" "E" Tom L Oshawa Program Analyst Ted Bundy Divisional Projects Sean T Whitby Manager Ted Bundy Divisional Projects Wendy J Pickering Clerk Tom Jackson Change Mgmt Andy D Ajax Installer Ted Bundy Divisional Projects |
All times are GMT +1. The time now is 03:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com