500+ employees = 500+ worksheets

That will create quite a large workbook and become very difficult to manage,
especially when editing employee data.

You may want to reconsider.

Leave it all on one sheet so's you can filter by employee or set up a PivotTable
to manipulate the data.

See Debra Dalgleish's site for filtering and PT's

http://www.contextures.on.ca/tiptech.html


Gord Dibben MS Excel MVP


On Mon, 7 Jan 2008 01:26:02 -0800 (PST), wrote:

Good day all,

I am an Excel novice and would really appreciate assistance in regard
to the following:

I have a worksheet with employee names and employee no's each with
specific information per row.

I would like to have a worksheet created for each employee and have
specific information from the main worksheet to show on each worksheet
e.g. Employee name, Empl No., Basic salary etc. The created worksheets
then needs to do specific calculations e.g. % increase, basic montly
medical aid contributions, etc. I have already created the worksheet
which does all the calculations but have to now duplicate it for each
employee and insert each employee's specific information (more than
500 employees!). Is there a way in Excel or VBA in which this can be
done quicker and/or automatically? (please keep in mind I'm not an
expert in Excel or in VBA and would thus need a detailed explanation)

Thank you kindly!


Rennier