Pulling only last 30 days data from larger 'all - time' table

Hi,

I have a sheet that contains information about product performance issues. This sheet conatins all information from the full life of the product, but i would like to be able to pull that data from just the previous 30 days to another sheet. What is the best way to do this, given that I will be inserting new data into the all time sheet as it is available and the 'last 30 days' will obviously not be the same data range every time. I am ok with having to enter the date range I want to pull to the new table if there is a way to do that as well.

Thanks!

So, do you want to specify a start date (the end date is 30 days after that), or do you want to select a month from a drop-down and have the new table populate for the chosen month?

Do you want all columns of the data from the main sheet to be copied across?

Pete

HI,

Thanks for the quick response! Yes I would like all columns to be copied (the real table has a few more columns that the example I included).

And, Yes I would like to specify the date range because sometimes this report is run at times other than end of month, I may need to pull data from 6-18-12 to 5-18-12 for example.

Thanks!

Okay, you don't need to specify the end date, as it will be 30 days from your start date and we can get Excel to add on those 30 days.

I've renamed your original sheet Main, and set up a new sheet Recent. In both of them I've inserted a new column A with this formula in A2 of Main:

Formula:

Please Login or Register  to view this content.

this compares the date with the start and end dates and sets up a simple sequence for records whose date is within the range.

In the Recent sheet you can set your starting date in cell C1 (coloured yellow). This formula in A4:

Formula:

Please Login or Register  to view this content.

finds where the records with an appropriate date in the Main sheet are located, and this formula in B4:

Formula:

Please Login or Register  to view this content.

brings the corresponding data across from column B. This formula can be copied across to E4, though you will need to change to a date format for cell C4. These formulae can then be copied down as far as you think you may need - the hypens indicate how far you have copied.

Hope this helps.

Pete

Thank you this is great

@ frichmond

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.