Copying every row with Jan date automatically onto another worksheet?

  • Thread starter Thread starter matt_the_brum
  • Start date Start date
M

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
 
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
 
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
 
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
 
Back
Top