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