Array based on dates / multiple workbooks?

[mitelkm]

Hello all,

First and foremost, thank you for reading this post.

I am trying to do the following: (if possible)

I have to fill out these really long spread sheets, in a multiple sheet wkbk. What I have realized, however, is that all of the information that is required on these long sheets, I have scattered through other workbooks.

I believe I need an array since data should only be carried over based on date conditions. I do not want a regular if/and/vlookup, because I have over one hundred jobs that will need to be split up on different sheets in my report depending upon the month they occur. So, I am thinking if I have an array, rather than seeing a bunch of blank rows, I can see the jobs row after row, with no blanks.

Okay so:

So, in book 1 "sheet 2 " (Cell A4) I need to retrieve data from Book 2 "sheet 1" (column b) if the cell contents of (column z - book2) is greater or equal than August 1st(C4) , but less than or equal to August 31st(D4)....

Can anyone help me with this formula?

Of course in each column my criteria would be a little but different, but if I can get help with the above, I should be able to manipulate the formula for all of the other columns.

Thanks again!!!!!

[Cheeky Charlie]

I believe I need an array since data should only be carried over based on date conditions. I do not want a regular if/and/vlookup, because I have over one hundred jobs that will need to be split up on different sheets in my report depending upon the month they occur. So, I am thinking if I have an array, rather than seeing a bunch of blank rows, I can see the jobs row after row, with no blanks.

This doesn't make sense to me, sounds like a regular if/vlookup formula would work just fine.

This is quite hard to follow. Do you think you could create a workbook with sheets representing your various sources? (i.e. name the sheets 'book1 sheet 2', 'book2 sheet1').

There's no way i can create a formula based on your current description...