Please Help...I know there is a way to do it.

[hudsoncw]

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?

 

[vavs]

You can create a macro to add the two columns into a spreadsheet. You can then save the macro to your personal macro workbook. You can then call the macro from any workbook that you open.