Any Excel Experts?

[Mulder]

I'd really appreciate some help with this problem.

I've got about 7 sheets in an excel file, all rows have dates and other data. I'd like to make a new sheet that auto pulls any rows that have dates in the next ten days? Basically an auto generating to do list.

I've googled around lookups, lookupifs, vlookup etc and am totally lost.

Anyone know?

TIA

 

[Mulder]

use IF commands?

=IF(Sheet2!B5<TODAY()+10,Sheet2!C5,)

ie. less than 10 days in the future, then pull the value from the adjacent cell, else do nothing

nestle them if you then want to then look in the next sheet if the first one doesn't have anything

I've tried this and it's just says 0. Been working on it all day and its driving me nuts.

 

[Mulder]

Why did you entirely ignore Rich L's suggestion of collating the sheets? At least help us to help you by explaining why you can't just combine all the data into one sheets and pivot / autofilter.

People will be adding to the other sheets all the time and there's a fair amount of data. How would I properly link them so it auto updates?