Ok excel professionals I have a new challenge for you. I am going to attach a file that is a copy of the master I use. I have had you all help me with other formulas within it before and wonderful success.
The way I use this file is in tab one (named MASTER) I input the info you will see in the sample. This page is fluid on an everyday basis from new info, changed data within the row, rows moved up and down within that page, or even deleted rows with data. Example: John Doe 66 came in today to be seen. all of his info would be put into the next open row in master tab and the date in would be today. (date in hardly changes but sometimes has to) then about 8 more John Does all come in after the first one. again all done the same way and in order to start. as the process works out John Doe 69 might be completed and his date out is before John Doe 66 so I will copy and paste his row (within the master) above John Doe 66 and mark him complete. and do that each time one is complete until they all are. (make sense?)
In the past once the end of each month was up I would copy and paste all the data in the master that fit within the "Date In" column and paste that data in the corresponding tab at the bottom. so if the date in was between 01/01/17 and 01/31/17 then everything would be pasted in the JAN tab. this worked however it moved the already set up formulas within each monthly tab which then changed all of the totals and everything else the rest of the way.
I would have to move it back up and change the numbers within the formula etc.. it just didn't work like I'm sure it can. **side note I want all the formulas that are set within each tab to never change if that's possible
What I would like is once I type in data in a row in the master tab and type in a date in the "Date In" row that data within that row is also copied into the tab named for that month. so 1/05/18 would be copied into JAN tab in the next open row. then as I change the data within that row again in the mater it also changes it in the JAN tab to match the same thing. (the kicker here is as they move to complete I typical move them to the top of the master sheet so that they are all in a row by the date out and I change the font color from black to red.) You will be able to see this in the sample I am attaching. So like I said the data in the master sheet will change everyday. and i would like for the data within each tab to change with it automatically and go off of the "date in" as to where that data is.
Ok I will stop there and if you have questions which I'm sure you will because I know I didn't explain this very well. thanks again everyone you have always been such a huge help to me.
Bookmarks