Pull data from one worksheet to another if date is within range.

Hi! New here and looking for some help, i'm quite a novice excel user! Apologies if this is really obvious.

I am creating a spreadsheet with a master page (named currently ALL), if you will, and then 12 seperate sheets/tabs, to show the information in monthly increments. What would be the best way to go about getting, for example, the January worksheet to contain all the information entered in the master page (ALL) between 01/01/17 and 31/01/17. So if cell AB3 = 25/01/2017 I want the entire row 3 data to duplicate into my January tab on the first available space.

It will be easier to show you this if you attached a sample Excel workbook, so we don't have to guess how your data is laid out and what you want to do with it.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

Thanks for your reply! I have attached the spreadsheet, any help you can give me is much appreciated.

Thanks John, that worked great, aside from a section where I have a drop down list now, that doesn't seem to be pulling through. Would this need a change to the formula?

Where is the drop down - I can't see any in ALL? and having it should make no difference. Whatever is selected should be copied.

so please post latest version!

Sorry, now attached

Password protected!!!!

Password is induction

See post #11

Thanks John. The drop down is appearing fine within the workbook and pulling as necessary. What I mean though is if I create a copy of this workbook for some of the departments within that drop down menu can I formulate the copy for it to then only show that departments information.

If you wish to select a particular Department then use a separate drop-down of Departments independent of the one in "ALL". And how will you handle a report for more than one (or all) departments? And do you want to also select a particular month?

So any month tab would only contain the data for the last selected department (if you have selection by department).

Maybe you need a separate "Report" tab(s) for selecting a particular month and department.

See attached which has tab "Dashboard" and a drop down in C1

new formula in "JAN"

=IFERROR(INDEX(ALL!A$3:A$1000,SMALL(IF((MONTH(ALL!$AB$3:$AB$1000)=1)*(ALL!$K$3:$K$1000=Dashboard!$C$1),ROW(ALL!$A$3:$A$1000)-ROW($A$3)+1,""),ROWS($A$3:A3))),"")

the asterisk "*" is an AND condition so we are selecting on MONTH and DEPARMENT.