I download a spreadsheet everyday titled "All Records". I need to copy and
paste specific data into an existing macro from the "All Records" tab to
other tabs in the workbook. (by the way, this is my first attempt at working
with multi tab workbooks so I really appreciate your help). The column
headings I need to base my copy and paste on are titled, "Match" and
"OriginalTBL" (there are 4 other columns but I wont' be using those in the
sort criteria at all) on all my sheets.

My book has 12 tabs labeled "All Records", "Confirm", "GESV", "GESA" and so
on. I only want to copy and paste the rows from the "All Records" table to
the "Confirm" tab the meet the criteria of "No Match" in the "Match" column
and "Confirm" in the "OriginalTBL" column.

On a separate tab I want to copy and paste the rows from the "All Records"
tab to the "ConfirmALL" tab that meet the criteria of "No Match" and "4-$" in
the "Match" column and "Confirm" in the "OriginalTBL" column.

I have many other taps to code but I know if I get help with these two, I'll
be on my way. Thanks so much. Joyce