automatically coping entire rows to new sheets when date is entered

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

Book1.xlsx

Thank you for the reply. Sorry about that. Here is a copy of the file. I need to know if I can populate each sheet with the totals from the column it coincides with. The total month is on page one and then is broken down into departments. Example: "Ch, Di, Ni, Po" have to be totaled on a different page. Seems like it can be done but its way too deep for me.
Thanks

Thank you to everyone that has replied. What I'm looking for is to take each column "Ch, Di, Ni and Po" and put on the coinciding sheet as follows. Customer, Invoice, hours and Billed. All the other columns were just what was being done previously. All fields on the new sheets (Ch, Di, Ni and Po) are changable. Its a work in progress at the monent. So far I have condensed the job to what we see in the sample sheet I posted. Believe it or not they were still doing all this by hand. If I can just get this last bit to transfer when a departmen is filled(Ch, Di, Ni or Po) and automatically fill each sheet i can reduce the labor. The only thing I need on each coinciding sheet is a department total. The departments fll under columns I, J, K and L. All other totals only need to be on the month end sheet which is the 1st sheet.

Thank you dredwolf for your reply. I am not looking so much for a total. What I need is for all information on each line to show in the sheet that coincides with the column. Example: The first dollar amounnt to show is for column K "Ni" for $175.00. So I need all informtion from row "4" to transfer to sheet "Ni". If I can get this information to transfer automatically I can finish each sheet setup.

Yes FDiddins and thank you very much. I'm having trouble looking at what you sent from my home computer. I only have a preview window from here. I can check it again tomorrow from work. At a glance it looks like it might help. The information I really need is the "Invoice number, Customer, Hours and "Column" total. The column total being the dollar amount for each department. (Ch, Di, Ni, and Po). But I will settle for the whole row transfering to a sheet.

That would be wonderful dredwolf! the information on the sheets (Ch, Di, Ni and Po) were just what someone else was doing with this project. I am trying to combine all in one. This might look like a mess but the beginning was a nightmare. My only concern was having the rows copy over to a second sheet as the information was put into the first.

Sorry dredwolf my bad on that one. It would be Invoice, Journal Transaction, Hours then Columns "I, J, K or L" (Ch, Di, Ni or Po") That would be the relevant information but I will settle for the whole row if I have too. You guys are the best

Thank you dredworf and FDiddins I will look at it in the morning. You guys ahve been a lot of help. Any thing is better than the stone and chisel method these guys were using before. Its been a long three month. I will update you on the progress in the morning.

Book1.xlsx

I looked at the Pivot Table file this morning. I could use this but it pulles in all the information and I'm only looking to fiter out. I have attached a new copy of the test file. It shows Ch and Di filled in from the information on sheet1. If sheet1 were really this small it wouldnt be a problem but sheet1 can grow to over 1000 rows each month. I was looking to see if when a column like "Ch" was populated can I get the sheet to automatically copy that row to sheet2? no other rows just the rows that have something in Column "Ch". Likewise on the other sheets for the corresponding rows. Thanks for the replies

Wow dredwolf! This is brilliant! I will test it tomorrow and get you feedback. Looks good so far but I will have to check the full file.
Thank you so much.....update to follow

Hello dredwolf. It's been a busy morning. I took a better look at the formula you posted. One again it is brilliant. I was playing with it when I noticed it copies the total of each order. That is what sheet one does amoung other things. What I was looking for was to split the total between the departments. For instance: Invoice 126341 has a total of $389.20. I have to find a way to split it between Ni ($179.20) and Po ($210.00) without having to copy/past or retype a month of information. This split will get me department gains or losses once I have compiled the numbers on separate sheets. I am still playing with your formula to see if I can figure it out. Thanks so much for the help

Thank you so much for everyone for the help. This worked beautifully!

Hello! Its me again. I know this thread was solved but I have an add on to this original problem. I have been asked to break down the numbers further but can't seem to get the formula correct. I have Book1.xlsxbeen double checking for three days. Running different tests but still don't know what I am doing wrong. Can anyone help