Copying every row with Jan date automatically onto another worksheet?

[matt_the_brum]

I have a main worksheet (Enquiries) containing all data. I column D i
the date. I want to transfer all rows with January dates to anothe
worksheet (Jan) automatically. So if I do update a row with a Jan dat
on Enquiries worksheet it will update itself on Jan worksheet

 

[Frank Kabel]

Hi
you may try the following array entered formula on your January sheet
(entered with CTRL+SHIFT+ENTER). Assumption: you start in row one:
=IF(INDEX($A$1:$A$1000,SMALL(IF(MONTH($D$1:$D$1000)=1,ROW($D$1:$D$1000)
,10000),ROW()))="";"";INDEX($A$1:$A$1000,SMALL(IF(MONTH($D$1:$D$1000)=1
,ROW($D$1:$D$1000),10000),ROW())))
copy this down. This will place the contents of column A in your second
sheet. Repeat this for the other columns

 

[matt_the_brum]

Thanks for help. Not sure how you came up with that formula. Not quit
working and have no idea why so will just copy and paste across
think. Thanks,
Mat

 

[Frank Kabel]

Hi Matt
what is your problem with the formula
One problem could oocur if you don't start in row one. You have to
adapt this formula for this situation.
If you like mail me your sheet, state where you want the output and
i'll set-up the formula for you
frank[dot]kabel[at]frenet[dot]de