On Apr 28, 4:13*pm, dan dungan wrote:
Hi Frank,

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

You wrote:
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


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