I get emailed a spreadsheet every other day with sample data information on it. I have taken one spreadsheet and typed our specifications beside the values and wrote if/then statements to evaluate accept/reject. Is there a way I can save the two columns of info (spec & if/then) and paste them into a new sheet when it gets emailed to me without having to open the saved sheet and doing a copy/paste?
