It sounds like you are talking about Excel, but this is a forum for Exchange Server. I would post in the excel forums: http://social.technet.microsoft.com/Forums/en-us/excel/threads http://answers.microsoft.com/en-us/office/forum/excelTim Harrington | MVP: Exchange | MCITP: EMA 2007/2010, MCITP: Lync 2010, MCITP: Server 2008, MCTS: OCS | Blog: http://HowDoUC.blogspot.com | Twitter: @twharrington

I have a work book with four work sheets. I enter data on the first and the 2nd, 3rd and 4th collect my entries from the 1st. Does anyone know of a formula that will cut any line items from sheet 1 and place the cut row(s) on sheets 2, 3 or 4? Currently on sheet 1, I am using column A to enter a 1, 2, or 3 to run my formula's to copy those lines to sheets 2, 3, or 4. Any help will be greatly appreciated.

It sounds like you are talking about Excel, but this is a forum for Exchange Server. I would post in the excel forums: http://social.technet.microsoft.com/Forums/en-us/excel/threads http://answers.microsoft.com/en-us/office/forum/excelTim Harrington | MVP: Exchange | MCITP: EMA 2007/2010, MCITP: Lync 2010, MCITP: Server 2008, MCTS: OCS | Blog: http://HowDoUC.blogspot.com | Twitter: @twharrington