I have a sheet that the log is for a month. Each day has several orders and detail on each row. These days are broken into 4 column's that show what department(I,J,K and L) the order was from. I have four sheets in the same book that I use to break the month up into departments. I need to know if it is possible to automatically copy row information to different sheets when the value in the column each department is populated. I am inserting a picture of the sheet. It shows the different columns and you can see the four other tabs on the bottom. Thanks Untitled1.png
Bookmarks