Tick Box Macro
 

I have a number of data tables in the same sheet (each table is
separated by a blank row) I want to set up a macro that uses tick boxes
(would be located in Column I) to transfer the values in the rows that
are ticked to another spreadsheet where the tables would be sorted
based on table title.

Example of the a table (below it would be another table with a blank
row between the two tables)

Column
A................................................. .........................Column
H
Title
A..................14........45........3.........1 .3....$5,760....$1,157.....20.1

B...................4..........7........1......... 1.6.......$896.......$161.....18.1

C.................10.........33.......3..........2 .4.....$4,224......$881.....20.9

Total for
X.....28........85...........................$10,8 80....$2,199.....20.2


Anyone have any thoughts on how I would go about doing this? If you
could provide a sample VBA it would be greatly appreciated.

Thank you.


--
Vlad999
------------------------------------------------------------------------
Vlad999's Profile: http://www.excelforum.com/member.php...o&userid=33586
View this thread: http://www.excelforum.com/showthread...hreadid=533634