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

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


On Jan 7, 4:59*pm, rennier.coet...@za.abb.com 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 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

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"
--
JB


"(E-Mail Removed)" 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 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
>

On Jan 7, 11:03*am, carlo <carlo.ramu...@gmail.com> wrote:
> 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
>
> On Jan 7, 4:59*pm, rennier.coet...@za.abb.com 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 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- Hide quoted text -
>
> - 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