Create a calculating macro

[Rosemarie]

Need to create a macro to calculate step progression by date and frequency
-job code vs. # of steps (steps could be 1-11), and stop when maximum # step
is reached.
2) automatical calculate, job code vs. step frequency (4, 6, etc., week
before next step progression).
3) then calculate by date.
4) exclude employee's that have reached maximum step by entering a yes or no

 

[Steve Schapel]

Rosemarie,

Perhaps if you could give a specific example, we may have a better
understanding of what you mean...

 

[Rosemarie]

I appreciate your assistance. What I am trying to create is an Excel macro..

Employees at my company get pay raises in steps (step progession) every so
many weeks. I want to create a macro/s that will calculate by "job code" vs.
the "#" of steps to the next "step progression" (weeks):

step progression by date and frequency
job code vs. # of steps (steps could be 1-11), and stop when maximum #
step is reached. and, calculate job code vs. step frequency (4, 6, etc., week
before next step progression).
then calculate by date.
exclude employee's that have reached maximum step by entering a yes or
no

 

[Steve Schapel]

Rosemarie,

The focus of this newsgroup is macros in Access, the database program.
Macros in Access are totally different creatures from macros in Excel. You
will have a better chance of a good reply if you re-post to an Excel
newsgroup. But even there, I suspect you will need to be more specific in
the information you supply. You will have to say which columns you have in
your worksheet, and show some *examples* of your data, and some *examples*
of how you work this step progression stuff out.

 

[Rosemarie]

Yes, I will do just that. It was late when I posted question, and I did not
realize that I had selected Access Database. Thanks for the column tip, as
well.