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