Hi All,
Could anybody give me a piece of code to do the following:
I have a master spreadsheet and I am trying to copy rows which meet criteria from 2 columns into existing worksheets. If column C ="Open" and column P is >0 then copy entire row into worksheet Open Orders or if column C ="Closed and column P is >0 then copy entire row into worksheet Closed Orders.