Extracting data to another sheet- Date range- monthly

[MorganB]

Hello,
I am struggling with a new spread sheet for tracking our jobs per year.
I have created a workbook with the sheets- JOBS,CALENDAR,JAN,FEB,MAR,APRIL ETC
The Jobs work sheet has 17 rows (a-q) of information that we require to complete the job. We complete about 1500 jobs per year- roughly 30 jobs per week.
I want to use this sheet to enter all jobs- a database if you will and have it automatically or via a button copy the entered info to the corresponding month. (all 17 rows)
The date that I need it to sort from starts at "O4:O1504" this is our install date that everything works from.
I have tried an array and vba code but nothing I do seems to work.
I have spent hours trying to upskill myself to get this to work but I cannot.
Any help would be greatly appreciated.

 

[Bill Rockenbach]

1. Do you mean you have 17 "Columns" (a-q)
2. What is the "Calendar" sheet used for.
3. Is the Jobs info appended or inserted by date to the Month sheets
4. After copying is it probable that there will be updates
5. If the Job date in Column "O" changes to a different month I assume you need to locate the original posted Job and delete it from that month.
6. What column is the Job number in

 

[MorganB]

1. Do you mean you have 17 "Columns" (a-q)
2. What is the "Calendar" sheet used for.
3. Is the Jobs info appended or inserted by date to the Month sheets
4. After copying is it probable that there will be updates
5. If the Job date in Column "O" changes to a different month I assume you need to locate the original posted Job and delete it from that month.
6. What column is the Job number in

1.yes
2.Calendar Sheet is where I merge the information to export to outlook. I have created a seperate thread for this
3.I want to enter the information into the jobs sheet and have it automatically transfer to the correct month which will be determined by install date column in column 'O'
4.Yes, I would be happy if it updated everytime it opens or via a button if you make changes
5.I thought this would happen automatically if using an array formula
6.our main indicator is Joiner name Column b and Client name Column C Job number is Column

i tried to get this formula to work across two sheets but couldnt.
=IF(ROWS(E$7:E8)>$G$4,"",INDEX(A$4:A$13,SMALL(IF($A$4:$A$13>=$E$4,IF($A$4:$A$13<=$F$4,ROW($A$4:$A$13)-ROW($A$4)+1)),ROWS(E$7:E8)))) (Mr Excel example 894)

Unfortunately i lost this in a black out yesterday, I will try again though.

Although I got the count to work which i find strange
=COUNTIFS( JOBS!A4:A1500,">="&JAN!S$4,JOBS!A4:A1500,"<="&JAN!T$4)

 

[MorganB]

=if(rows(jobs!$a$4:$a$1500)>jan!$t$6,"",index(jobs!$a$4:$a$1500,small(if(jobs!$a$4:$a$1500>=jan!$s$4,if(jobs!$a$4:$a$1500<=jan!$t$4,row(jan!$a$4:$a$200)-row(jan!$a$4)+1)),rows(jan!$a$4:$a$200))))
but it doesnt work