Question on VBA Insertion of Additional Sheet

[golf4wff]

Hi, Everyone -

I'm continuing to work on our agency Payroll Sheet.... seems like a
"never-ending battle"....

I have a quick couple of questions that I was hoping to obtain some
imput on:

Within my Payroll Sheet, I have what is called a Data Entry Sheet
where the employee manually enters their hours (both paid and Leave),
and the numbers are fed over to the actual Payroll Sheet where
everything is more or less calculated out and summarized. We now have
an employee that will need a SEPERATE Data Entry Sheet for each
project he works on, so that he will have one actual Payroll Sheet but
15 seperate Data Entry Sheets. What I would like to do is to set up a
VBA button that, when pressed, XL will copy the original blank Data
Entry Sheet (along with all formatting and security settings) and
insert the copies sheet as a new sheet. Can someone help me out with
the code strips to make this possible?

Thanks.

Frank

 

[dan dungan]

Hi Frank,

I don't know if I can be helpful here, but I had a question:

I have what is called a Data Entry Sheet
where the employee manually enters their hours (both paid and Leave),
and the numbers are fed over to the actual Payroll Sheet

How are the numbers fed over to the actual payroll sheet?
If you copy the Data Entry Sheet 15 times, how will the payroll sheet
now about them and add them up?

Dan

 

[golf4wff]

Hi Frank,

I don't know if I can be helpful here, but I had a question:


How are the numbers fed over to the actual payroll sheet?
If you copy the Data Entry Sheet 15 times, how will the payroll sheet
now about them and add them up?

Dan

Hi, Dan -
Thanks for the quick response. I'd be the VERY FIRST to admit I'm a
novice at programming, so this may seem extremely rudamentary. The
tool that I have created as "Test" works like this: I manually created
5 new sheets by Cntrl+C the original Data Entry Sheet so that now I
have (1) the summary Payroll Sheet itself where it takes the daily-
entered hours off the original Data Entry Sheet; (2) the original Data
Entry Sheet; and (3) the 5 new Data Entry Sheets.

The way it KIND OF works is that the employee would enter hours on the
individual Data Entry Sheet, for each seperate project which would
then feed over into the original Data Entry Sheet and the hours would
get "summed" up for each day. Then those hours would feed over into
the Payroll Sheet itself.

I can email you a copy if you'd like.......... Does this explain it a
little better?

Thanks again.
Frank

 

[dan dungan]

Hi Frank,

Well, it seems that you can manually add the sheets you need, but you
want a macro to do it, right?

I would start with recording the macro while you manually insert the
new sheets.

Then let's see what code you get.

Dan