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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

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,109,388
Messages
5,528,408
Members
409,817
Latest member
JiNXX9500

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top