J
Janine
Hi all,
What I have is a worksheet with the details ie. job no, client etc. I
basically have eleven Header colums. I then have 2000+ rows with job
numbers and clients, this already has a macros to copy them into a
invoice on sheet 2.
What I need is a way to seperate the clients details and job numbers
automatically into a different worksheet or onto another sheet within
the current worksheet.
I would ideally like to be able to enter information on sheet one, then
get my invoice on sheet two have 7 seperate sheets with clients names (
this would name 12 sheets) and have excel recognise the client and when
i update file place it there by job number. ]
If anyone can help i back at work on monday and woud really appreciate
all the help i can get.
Access is not available, i have already asked!!!!
What I have is a worksheet with the details ie. job no, client etc. I
basically have eleven Header colums. I then have 2000+ rows with job
numbers and clients, this already has a macros to copy them into a
invoice on sheet 2.
What I need is a way to seperate the clients details and job numbers
automatically into a different worksheet or onto another sheet within
the current worksheet.
I would ideally like to be able to enter information on sheet one, then
get my invoice on sheet two have 7 seperate sheets with clients names (
this would name 12 sheets) and have excel recognise the client and when
i update file place it there by job number. ]
If anyone can help i back at work on monday and woud really appreciate
all the help i can get.
Access is not available, i have already asked!!!!