Adv Filter City
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Adv Filter City as PDF for free.
More details
- Words: 424
- Pages: 8
Monthly Summary
Send data to she
BAKERSFIELD GAINESVILLE ODESSA ODESSA ODESSA ODESSA ODESSA COLUMBUS BAKERSFIELD COLUMBUS COLUMBUS COLUMBUS GAINESVILLE BAKERSFIELD GAINESVILLE GAINESVILLE COLUMBUS COLUMBUS
TOTAL
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
CITY NAME
DATE
17-Oct-08
1/1/2004 6 95 36 52 77 266 1/2/2004 59 47 30 62 65 263 1/3/2004 28 83 82 59 99 351 1/4/2004 23 70 98 24 53 268 1/5/2004 100 68 2 58 10 238 1/6/2004 80 28 5 30 38 181 1/7/2004 95 98 40 28 16 277 1/8/2004 65 41 41 71 33 251 1/9/2004 21 19 58 8 46 152 1/10/2004 26 79 38 29 92 264 1/11/2004 63 43 10 56 69 241 1/12/2004 83 2 54 92 43 274 1/13/2004 6 24 98 6 39 173 1/14/2004 78 46 75 60 83 342 1/15/2004 21 7 11 33 13 85 1/16/2004 54 66 54 83 8 265 1/17/2004 68 45 36 15 70 234 1/18/2004 21 33 10 59 17 140
Enter the data in the 'Send data to send the data to
A message box w (Rows 1:3) should
To view the macro 1. Choose Tools> 2. Select 'FilterCit 3. Click Edit
Send data to sheets
Enter the data in this list, then click the 'Send data to sheets' button, to send the data to the City sheets. A message box will ask if headers (Rows 1:3) should be copied. To view the macro code: 1. Choose Tools>Macro>Macros 2. Select 'FilterCities' 3. Click Edit
BAKERSFIELD BAKERSFIELD BAKERSFIELD
TOTAL
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
DATE
CITY NAME
1/1/2004 6 95 36 52 77 266 1/9/2004 21 19 58 8 46 152 1/14/2004 78 46 75 60 83 342
GAINESVILLE GAINESVILLE GAINESVILLE GAINESVILLE
TOTAL
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
DATE
CITY NAME
1/2/2004 59 47 30 62 65 263 1/13/2004 6 24 98 6 39 173 1/15/2004 21 7 11 33 13 85 1/16/2004 54 66 54 83 8 265
COLUMBUS 1/8/2004 COLUMBUS 1/10/2004 COLUMBUS 1/11/2004 COLUMBUS 1/12/2004 COLUMBUS 1/17/2004 COLUMBUS 1/18/2004
65 26 63 83 68 21
41 79 43 2 45 33
41 38 10 54 36 10
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
DATE
CITY NAME
71 29 56 92 15 59
33 92 69 43 70 17
TOTAL
251 264 241 274 234 140
ODESSA ODESSA ODESSA ODESSA ODESSA
1/3/2004 1/4/2004 1/5/2004 1/6/2004 1/7/2004
28 23 100 80 95
83 70 68 28 98
82 98 2 5 40
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
DATE
CITY NAME
59 24 58 30 28
99 53 10 38 16
TOTAL
351 268 238 181 277
Send data to she
BAKERSFIELD GAINESVILLE ODESSA ODESSA ODESSA ODESSA ODESSA COLUMBUS BAKERSFIELD COLUMBUS COLUMBUS COLUMBUS GAINESVILLE BAKERSFIELD GAINESVILLE GAINESVILLE COLUMBUS COLUMBUS
TOTAL
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
CITY NAME
DATE
17-Oct-08
1/1/2004 6 95 36 52 77 266 1/2/2004 59 47 30 62 65 263 1/3/2004 28 83 82 59 99 351 1/4/2004 23 70 98 24 53 268 1/5/2004 100 68 2 58 10 238 1/6/2004 80 28 5 30 38 181 1/7/2004 95 98 40 28 16 277 1/8/2004 65 41 41 71 33 251 1/9/2004 21 19 58 8 46 152 1/10/2004 26 79 38 29 92 264 1/11/2004 63 43 10 56 69 241 1/12/2004 83 2 54 92 43 274 1/13/2004 6 24 98 6 39 173 1/14/2004 78 46 75 60 83 342 1/15/2004 21 7 11 33 13 85 1/16/2004 54 66 54 83 8 265 1/17/2004 68 45 36 15 70 234 1/18/2004 21 33 10 59 17 140
Enter the data in the 'Send data to send the data to
A message box w (Rows 1:3) should
To view the macro 1. Choose Tools> 2. Select 'FilterCit 3. Click Edit
Send data to sheets
Enter the data in this list, then click the 'Send data to sheets' button, to send the data to the City sheets. A message box will ask if headers (Rows 1:3) should be copied. To view the macro code: 1. Choose Tools>Macro>Macros 2. Select 'FilterCities' 3. Click Edit
BAKERSFIELD BAKERSFIELD BAKERSFIELD
TOTAL
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
DATE
CITY NAME
1/1/2004 6 95 36 52 77 266 1/9/2004 21 19 58 8 46 152 1/14/2004 78 46 75 60 83 342
GAINESVILLE GAINESVILLE GAINESVILLE GAINESVILLE
TOTAL
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
DATE
CITY NAME
1/2/2004 59 47 30 62 65 263 1/13/2004 6 24 98 6 39 173 1/15/2004 21 7 11 33 13 85 1/16/2004 54 66 54 83 8 265
COLUMBUS 1/8/2004 COLUMBUS 1/10/2004 COLUMBUS 1/11/2004 COLUMBUS 1/12/2004 COLUMBUS 1/17/2004 COLUMBUS 1/18/2004
65 26 63 83 68 21
41 79 43 2 45 33
41 38 10 54 36 10
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
DATE
CITY NAME
71 29 56 92 15 59
33 92 69 43 70 17
TOTAL
251 264 241 274 234 140
ODESSA ODESSA ODESSA ODESSA ODESSA
1/3/2004 1/4/2004 1/5/2004 1/6/2004 1/7/2004
28 23 100 80 95
83 70 68 28 98
82 98 2 5 40
DEPT5
DEPT4
DEPT3
DEPT2
DEPT1
DATE
CITY NAME
59 24 58 30 28
99 53 10 38 16
TOTAL
351 268 238 181 277
Related Documents
Adv Filter City
November 2019 7
Adv Filter Search Word
November 2019 13
Filter Adv Criteria
November 2019 19
Adv Filter Budget
November 2019 12
Adv Filter Rep Filtered
November 2019 11