Could someone please help with a quick Macro. I have a workbook with two worksheets in it. The first sheet requires the user to type in some information into cells B12 to B18. When they are done they go to sheet #2 and print out the form they require (using, in part, that information). I need a macro that will automatically clear cells B12 to B18 on sheet #1 when the user goes back to sheet #1 from sheet #2. I only need the cells cleared when they go from sheet 2 to 1, not 1 to 2.
Thank you in advance for any help you can give.