Creating different worksheets from a main worksheet

[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 this possible and if so how can I do it (keeping in mind I'm not an
expert in Excel or in VBA)?

Thanks!

Rennier

 

[carlo]

Hey Rennier

well it is possible in VBA.

You would do the following (in words)
you would go through the whole list
for each entry in the list you would duplicate the sheet
change the sheet name
enter additional information
go to next entry

Just ask if you want to know more.

Cheers
Carlo

 

[john]

There ia a good example you can download from this site:
http://www.contextures.com/excelfiles.html

which may do what you are looking for. choose FL0013 from example list:

"FL0013 - Create New Sheets from Filtered List -- uses Advanced Filter to
create separate sheet of orders for each sales rep visible in a filtered list"

 

[rennier.coetzee]

Hey Rennier

well it is possible in VBA.

You would do the following (in words)
you would go through the whole list
for each entry in the list you would duplicate the sheet
change the sheet name
enter additional information
go to next entry

Just ask if you want to know more.

Cheers
Carlo







- Show quoted text -

Hi Carlo,

Thanks for the quick comeback! I do understand what you are saying but
just don't know VBA to create a VBA macro to do this. Our computer guy
that usually helps in regard to Excel is still on leave (until 14
Jan) and I need to get spreadsheets created for every employee before
the end of this week!

Kind regards,

Rennier