Thread: Copying Tables

Hello

I have the following setup

A Table with infomation about how many scratchies have been sold that week.
the first three columns are purely informational, and the next 25 columns have calculations. the last column claculates weather a scratch-its book has been 'sold out' during the week.
Some weeks this table has gotten up to 80 rows (which means 80 scratchie books have been sold out or being sold)

What i need is a tutorial or website / link to explain how to,
1. copy the first 3 columns of this table into another work sheet, given the true / false parameter in the final column of each row.
2. this needs to be as automatic as possible, in that, if i have 10 rows, or 50 rows, all rows that need to be copied will be. and so the computer illitare users wont need to do anything except open the worksheet, enter some values, save and close.
3. i still need to have the copied data as a Table, so that i can reorder data as neccassary.

Attached is the full workbook, see "Sold Scratch-its" tab for an example of a completed week.

Thanks in advance

James