From Mr. Ogilvy and Mr. deBruin, I have
worksheets("Sheet1").Cells.Cop
worksheets("Sheet2").Range("A1").Pastespecial paste:=xlFormula
I'm having a little trouble with where to put it and how to put it there. I already have code on both sheets to color the cells based on text value. Do I add these two lines at the bottom of the existing code and if so which sheet do I add it to
Thanks in advance for any help
Erik