I use excel as a production program for our manufacturing company but
currently move everything over manually. When a job is quoted it gets
inputted in as follows; Date/quote #/Name/Accepted/Delivery Date. When the
job is accepted we type 'YES' under accpeted and put in an estimated delivery
date. When this is done I want that row to move to the month of the delivery
date in another sheet. Can anyone help

Here's a formulas driven model which delivers it ...

Illustrated in this sample:
http://freefilehosting.net/download/4021h
AutoCopy to Month Sheet.xls

In the source ("parent") sheet: x,
data is assumed in row2 down, where
key cols are col D ("Yes"),
and col E (est delivery dates - these are real dates)

List the MthYr as text* in G1 across, eg: Sep08, Oct08, etc.
*Either enter a leading apostrophe eg: 'Sep08, or preformat G1 across as TEXT

In G2: =IF($D2<"Yes","",IF(TEXT($E2,"mmmyy")=G$1,ROW()," "))
Copy G2 across/fill down to cover max expected extent of source data in cols
D & E

Click Insert Name Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")
))+1,32)
Click OK

The above defines WSN as a name we can use to refer to the sheetname in
formulas. It will auto-extract the sheetname implicitly. Technique came from
a post by Harlan.

Then in the 1st "child" sheet (a new sheet),
name it as the MthYr, say: Sep08

Paste the col headers from x into A1:E1
Place in A2:
=IF(ROWS($1:1)COUNT(OFFSET(x!$F:$F,,MATCH(TRUE,IN DEX(TEXT(x!$G$1:$K$1,"mmmyy")=WSN,),))),"",INDEX(x !A:A,MATCH(SMALL(OFFSET(x!$F:$F,,MATCH(TRUE,INDEX( TEXT(x!$G$1:$K$1,"mmmyy")=WSN,),)),ROWS($1:1)),OFF SET(x!$F:$F,,MATCH(TRUE,INDEX(TEXT(x!$G$1:$K$1,"mm myy")=WSN,),)),0)))
Copy A2 across to E2, fill down to cover max expected number of lines per
any delivery MthYr, say down to row50? The source lines for Sep08 which
satisfy the criteria will be autocopied from x and appear neatly bunched at
the top. Dress this child sheet up to taste. Then just make copies of this
sheet: Sep08, & rename these as the other MthYr, viz: Oct08, Nov08, etc.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"Kingdazza" wrote:
I use excel as a production program for our manufacturing company but
currently move everything over manually. When a job is quoted it gets
inputted in as follows; Date/quote #/Name/Accepted/Delivery Date. When the
job is accepted we type 'YES' under accpeted and put in an estimated delivery
date. When this is done I want that row to move to the month of the delivery
date in another sheet. Can anyone help

Here's a simpler version for the earlier extract formula in the child sheet,
which works just as well, and also extends it all the way to cover col IV in
the source sheet: x

In the child sheet: Sep08
Place in A2:
=IF(ROWS($1:1)COUNT(OFFSET(x!$F:$F,,MATCH(WSN,x!$ G$1:$IV$1,0))),"",INDEX(x!A:A,MATCH(SMALL(OFFSET(x !$F:$F,,MATCH(WSN,x!$G$1:$IV$1,0)),ROWS($1:1)),OFF SET(x!$F:$F,,MATCH(WSN,x!$G$1:$IV$1,0)),0)))
Copy A2 across to E2, fill down to cover max expected number of lines per
any delivery MthYr ... (Make copies of the child n rename the sheets as
before)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---

Wow Max that looks great, it's not quite what I'm after but it'son the write
track. I have uploaded acopy of the template on the linkyou sent through,you
will get a better idea of what I mean. Each month has a different worksheet
but they all need to be talking to each other.If there is a better way I am
open to suggestions.

Thanks
Darren.

"Max" wrote:

Here's a simpler version for the earlier extract formula in the child sheet,
which works just as well, and also extends it all the way to cover col IV in
the source sheet: x

In the child sheet: Sep08
Place in A2:
=IF(ROWS($1:1)COUNT(OFFSET(x!$F:$F,,MATCH(WSN,x!$ G$1:$IV$1,0))),"",INDEX(x!A:A,MATCH(SMALL(OFFSET(x !$F:$F,,MATCH(WSN,x!$G$1:$IV$1,0)),ROWS($1:1)),OFF SET(x!$F:$F,,MATCH(WSN,x!$G$1:$IV$1,0)),0)))
Copy A2 across to E2, fill down to cover max expected number of lines per
any delivery MthYr ... (Make copies of the child n rename the sheets as
before)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---

.. I have uploaded a copy of the template ...

Link? You forgot to post the link to your sample in your reply

P/s: I might not have another suggestion for you. Thought the earlier effort
was quite ok, but ... it's not good enough in your eyes, it seems.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100, Files:360, Subscribers:56
xdemechanik
---
"Kingdazza" wrote in message
...
Wow Max that looks great, it's not quite what I'm after but it's on the
write
track. I have uploaded a copy of the template on the link you sent
through,you
will get a better idea of what I mean. Each month has a different
worksheet
but they all need to be talking to each other.If there is a better way I
am
open to suggestions.

Thanks
Darren.

Max I really do apologies I didn't mean to offend you, it really wrote a lot
worse than I meant. What you have done is more than I had expected, I really
do appreciate it.

I didn't realise I needed to copy the link (am still not very computer
literate) so if you want please take a look at the following;
http://freefilehosting.net/download/403eh

I'm not sure but will it make it harder because we have each month in a
different workbook?

If you don't want to look at it I do understand, but please accept my
apologies.

Thanks again
Darren

"Max" wrote:

.. I have uploaded a copy of the template ...

Link? You forgot to post the link to your sample in your reply

P/s: I might not have another suggestion for you. Thought the earlier effort
was quite ok, but ... it's not good enough in your eyes, it seems.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100, Files:360, Subscribers:56
xdemechanik
---
"Kingdazza" wrote in message
...
Wow Max that looks great, it's not quite what I'm after but it's on the
write
track. I have uploaded a copy of the template on the link you sent
through,you
will get a better idea of what I mean. Each month has a different
worksheet
but they all need to be talking to each other.If there is a better way I
am
open to suggestions.

Thanks
Darren.