Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement to copy an entire row to other worksheet w/ in same b | Excel Worksheet Functions | |||
Copy data from other worksheet based on column header | Excel Discussion (Misc queries) | |||
copy graph from a Worksheet based on a field in another Worksheet | Excel Worksheet Functions | |||
copy data from 1 worksheet to another based on a condition | Excel Worksheet Functions | |||
GoTo Worksheet based on which button clicked | Excel Programming |