If you post some relevant excerpts of your code and some more specifics, it
owuld be easier to give you a good answer.
--
Vasant
"Charyn" wrote in message
...
Good evening NG!
I am currently studying accounting and have taken a class that expands our
(students) knowledge of excel, macros, etc. as they apply in the world of
accounting. Our term project was to create a payroll workbook in excel
that
used VBA, Macros and several other excel features to assist in the
weekly/yearly chores of processing payroll. I completed the project
within
the stated parameters, but in the process I have become totally intrigued
with VBA (enough to take a summer course for non-programmers) and know
that
there are things that can be enhanced beyond what we were expected to
accomplish.
OK - enough background - here's the puzzle I am trying to unravel:
The workbook I created taken user inputs to create employee records on a
roster. I then have a macro that I enhanced the VBA code for that
tranfers
all of the new employee data onto a payroll register for weekly payroll
and
an annual record specific to that individual. All of the taxes are
calculated through formulas gor deduction.
The problem I am having is in getting the formula for social security to
automtically populate on the weekly register. As SS is capped - the total
paid (on the annual record) is relevant to the formula to calculate the
amount of tax. I can hand enter the formula - pointing to the YTD gross
pay, but I would like to abe able to have that formula generated
automatically when the new employee is added to the payroll register and
their annual record is created.
Sorry for the long post - and Thanks for any direction you can point me :)
Charyn
|