Pulling information from one sheet to another

**boll55** · 11-27-2012, 11:19 AM

Hi quick simple question.

I need to pull information from one sheet to another based on a date.

I need all Physicals, CDLs and Haz Mats that are before (But not equal to) the date of 2/1/13.

I want to be able to change this date every month so im thinking some kind of helper cell with just the date and the formul would refernce that cell would be nice.

I have a attached a sheet.

http://www.ozgrid.com/forum/showthre...981#post637981

Book1.xlsx

**boll55** · 11-27-2012, 11:32 AM

Attached wrong file!!!!

**ChemistB** · 11-27-2012, 12:21 PM

Not such a simple answer, I'm afraid.

Here's what I did,
I put your date in cell B1 then in A3 (for example)

Formula:

Please Login or Register  to view this content.

This is entered as an Array, (use CONTRL SHFT ENTER instead of ENTER, you'll see brackets appear {} around the formula)
The SMALL(IF....) part brings back the rows that have values less than or equal to B1, The INDEX returns the corresponding values in the column you are interested in. i.e. Q for Birth date. You need to change the INDEX columns for each item you want moved. (If the headers on the two tables matched exactly, we could have automated this). See attached and let me know if you have questions.