Multiple copying of a Spreadsheet advice please

[Dermot]

I have a spreadsheet for a client.
It consists one worksheet of 6 pages, each representing 6 months of a 36
monthly period (inserted pagebreaks). The content refelcts hours worked per
employee and cost for their time. Employee hourly rates are different. The 6
monthly costs are subtotalled and the grand total is shown at the end.

What is the most effective way to account for many clients?
Copy and paste the next client under the first in the same worksheet or
Copy and paste into the next worksheet, (but this would limit me to 255
clients wouldn't it?).

Please advise, thanks in advance.

[raypayette]

One possibility is to build a sheet on demand, print it and then delete it. This way you would limit the number of sheets. I have successfully used this technique to make personal schedules for hundreds of employees.

[Dermot]

Thanks for the relpy raypayette,
I asm not sure I understand you. The spreadsheet I am using is on going as
the employee participation hours vary each month and need to entered on a
regular basis.

Any further suggestions Raypayette?

"raypayette" wrote:

>
> One possibility is to build a sheet on demand, print it and then delete
> it. This way you would limit the number of sheets. I have successfully
> used this technique to make personal schedules for hundreds of
> employees.
>
>
> --
> raypayette
>
>
> ------------------------------------------------------------------------
> raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
> View this thread: http://www.excelforum.com/showthread...hreadid=566379
>
>

[raypayette]

I suggested to keep it to your 6 sheets. I supposed that your employees' time was allocated to different clients. One way to calculate each client's cost is to filter the sheets according to each client, copy the information to a new sheet, produce the report and delete the sheet. You could produce these reports on demand, even if you have 400 clients!