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!!!!!!!

Please can you provide the layout of the existing sheet and how you
want the new sheets to look ?
Janine wrote:
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!!!!!!!

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











wrote:
Please can you provide the layout of the existing sheet and how you
want the new sheets to look ?
Janine wrote:
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!!!!!!!

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 wrote:
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











wrote:
Please can you provide the layout of the existing sheet and how you
want the new sheets to look ?
Janine wrote:
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!!!!!!!

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.

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?


Janine wrote:
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.