|
|
#7
06-13-2015, 12:04 PM
|
|||
|
|||
Hi,
I modified sheet "End" you had Merged cells. In this copy you will see a "Test" button when you click it the code will set a filter to look for "True" and copy the filtered range to the End sheet. You will need to clear the "End" sheet other wise the data will be going to the next empty row. You can modify the code to clear the "End" sheet when you run the code. Also I have the filter set to range '$K$2:$K$12". This can be modified to include more rows. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro to check dropdown value and increment a counter | rkferguson | Word VBA | 8 | 01-07-2015 11:08 PM |
 Tying a check box to a macro/VBA to customize a document
|
mhblake | Word VBA | 3 | 12-04-2013 04:17 PM |
|
Macro for check box in word
|
Jeannie Cornia | Word | 3 | 01-21-2013 06:00 AM |
| Check box macro help needed | Aflac | Word | 4 | 03-24-2012 07:11 PM |
|
Check Box Macro
|
Johnny thunder | Word VBA | 12 | 04-07-2011 04:47 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode