Moving rows of information from one table to another based on date

dhannant

New Member
Joined
Oct 2, 2014
Messages
10
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.
Overdues
JackPhil

<tbody>
</tbody>
TYPES/NDue DateReceivedReason OverdueTypeS/NDue DateReceivedReason Overdue

<tbody>
</tbody>
Part NumberSerial NumberDue DateOwnerType
651813jun2013JackE
98415Oct2014PhilAV
5617530Oct2014PhilAV

<tbody>
</tbody>

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

dhannant

New Member
Joined
Oct 2, 2014
Messages
10
So I take it by the lack of comments that this is probably not possible.
 

dhannant

New Member
Joined
Oct 2, 2014
Messages
10
alright so I've been playing around with other alternatives... I'm still trying to not have to do this with macros however am now open to it if I can't get anything else to work. I've been playing around with a pivot table that I've got layed out with the appropriate information however, when it builds the table it selects ALL of the raw data (the original example is cut pretty short. There are actually about 200+ tracked inspections). So obviously my sheet fills up quickly and doesn't look great. I'd like to display only the coming due and over due with the pivot table not the entire list. If anyone has any ideas please let me know...
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
hi.

With a better explanation of the requirement there will be a better chance of a helpful reply.

For sure what you want can be done, but what that is isn't clear.

regards
 

Watch MrExcel Video

Forum statistics

Threads
1,113,909
Messages
5,544,994
Members
410,647
Latest member
LegenDSlayeR
Top