Copy data based on IF statement into new worksheet using button co

T

TonyD

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
 
Top