so I may be wrong in looking at this but im trying an advanced filter to filter your "table" data based on the cells im looking at in your master sheet to reference the zone and promo number and ive got a system that works but everytime I tell vba to remove the filter to go the next time excel crashed I think based on the shear amount of data provided in the table sheet, im still new to vba so I may be looking at this the wrong way though