ok so here is my problem... I want the data in the table on the right (starting at column U) to move into 1 of two separate areas under the "Overdues" section based on the owner and depending on the current date. This is all used for tracking inspections and other work details. So if the inspection is due within 5 days or so it will input all the required information into the overdue section with owner "jack" being on the left and "phil" on the right. I would like this to be done without macros if possible. The "received" section should be left blank if possible since that will show when the item was delivered for the inspection. If you need to reorganize the Overdues section to make it easier it will be ok but I would prefer not to. Both sections are built the way they are based on indexing and information priority. (the master date on the right is organized by P/N and will be organized by S/N eventually and the overdue area is organized by the type, s/n and date). I couldn't figure out how to upload the sheet here so this is the basic layout below. Overdues starts in A8. This is being posted on 3oct so the s/n overdue (13Jul2013) and the one coming due within 5 days (5Oct2014) should both move to the "Overdues" section in their respective owner slot. Hope this helps explain the problem. Thanks for any help.
<tbody>
</tbody>
Overdues | ||||||||||||||||||||||||||||||
<tbody> </tbody> | ||||||||||||||||||||||||||||||
<tbody> </tbody> | ||||||||||||||||||||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>