Creating worksheets automatically

[rennier.coetzee]

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

 

[MartinW]

Hi Rennier,

That sounds like a large project that would be better suited
to a consultant who is sitting next to you and can discuss
all of your needs before tailoring the right setup for your
particular situation.

Having said that there are some people in these newsgroups
who have the time and would relish the oppurtunity to get
into a nice juicy project like you have described. Hopefully
one of these people will come along and offer their services.

I think it is very important that you get it right, right from the
start. A spreadsheet to handle 500 staff can get out of control
in the blink of an eye, if it is not properly constructed from the
very beginning.

I am not trying to dissuade you from seeking help in the newsgroups,
helping others is what these groups are about, however, I honestly
believe that you and your company would be much better served
by seeking the help of a professional Excel consultant in your local area.

HTH
Martin

 

[Don Guillett]

Without seeing the workbook, something like

for each n in range("yournamelist")
sheets("Template").copy after sheets(sheets.count)
with activesheet
.copy items from master sheet
end with
next n

 

[Gord Dibben]

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