Maybe I'm making something to hard, can this formula be made to paste the result as special (value only) That might eliminate the need for a macro in the workbook. Thnaks
Code:
=IF(SUMIF(Sheet1!P:P,"640533*",Sheet1!B:B)<250000, "", SUMIF(Sheet1!P:P,"640533*",Sheet1!B:B))
