SET UP AUTOFILL! Pleae HELP!!
 

Job # Job Name Company Bid Amount Origin Date Status

123 1st floor ABC Co. $5,000.00 09/22/2006 J


The above are columns on a spreadsheet. If a cell in the "Status" column is
"J", I need the information in that row to automatically copy to other
worksheets. When the information does copy, I need it to go to the next
available row.