Hello all. I am needing some help coming up with a function that works on a sales spreadsheet. What I am needing to do is once a different site other than the main site is listed on the sales spreadsheet, I need that info to automatically copy and paste into a different section of the same sheet for that particular site. We are needing to track how many support sites are contributing monthly to wholesale orders. So basically I have the main table which has date/customer/product/invoice/orig invoice amt/credit/final sale amt/initials/status/site. I'm needing any site other than PON to be copied and sent to a new table starting at A40 so we can keep track. Is this possible without needing the criteria on the table first? I'm needing to do this as the information is entered. I've tried IF/Then and then entering it in and it doesn't work. I've tried nesting the if/then, and tried matching functions. Nothing is seeming to work. Any help/advice would be helpful. Thanks.