Transferring data from one worksheet or workbook to another

[Janine]

HI all,

What I have is a worksheet with a header that has the subject details
ie. job number, client, etc

I really need a way to transfer the client information onto seperate
worksheets that automatically update while keeping the information in
numeretical order by job number.

I have already got sheet 1 with the details, sheet 2 has a macros that
was in place when i got here this copies a row into an invoice.

What i really need is 7 new sheets with the clients names and then have
excel transfer the data automatically in job number order.

If anyone can help please could you get back to me ASAP!!!!!!!

 

[steve_briz]

Please can you provide the layout of the existing sheet and how you
want the new sheets to look ?

 

[Janine]

The layout that i have is
Job number, client, contact, title, date started, status, assigned
to,deadline, print del, priority, Po.

These are in columns a - k. then below i have the details which go down
to about row 3273.
What i want is to have the information automatically transferred to
another workbook, with either a macros ( which i will need help with)
or a pivot chart ( again with the help) if i can't seperate the clients
then i will probably filter it, but will sill need to macros or another
formula.
if the layout can stay the same that would be great.

thanks in advance

 

[steve_briz]

In the first post you mentioned you want it on 7 sheets..
however in you second post you mentioned that work books.
If you want to separate by sheets...do you want a different cheet for
each client?

 

[Janine]

hi,

What i did want is about 7 sheets but i have been working at it and it
doesnt seem to work so if i can get a macros and then filter it for
each client then it may work. so long as it is done automatically. but
what i found yesterday is that i will have to open a new workbook
either way as it doesnt accept that much information and refused to
open. when i inserted the formula =if(sheet1!a1="","",sheet1!a1), it
seemed to overload.

So to get to the point i need a new workbook with a macros that
transfers the data from the old one. this can either be done on
seperate sheets or on one and then i will filter the data.

Thank you.

 

[steve_briz]

I will be able send you some code soon...and how to implement it
however...there is few things I need to know

1/ is there any formulas( eg: totals at the bottom) you want to copy
from sheet1 to each of the Client sheets
2/ is there any blank rows interspersed in data rows you want preserved
in the client sheets?