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

Rosemarie,

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

--
Steve Schapel, Microsoft Access MVP


"Rosemarie" <(E-Mail Removed)> wrote in message
news:1E50DE69-562A-4A1B-8139-(E-Mail Removed)...
> 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

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

> Rosemarie,
>
> Perhaps if you could give a specific example, we may have a better
> understanding of what you mean...
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "Rosemarie" <(E-Mail Removed)> wrote in message
> news:1E50DE69-562A-4A1B-8139-(E-Mail Removed)...
> > 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
>
>

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.

--
Steve Schapel, Microsoft Access MVP


"Rosemarie" <(E-Mail Removed)> wrote in message
news:FB5C02FE-EB8C-432D-885E-(E-Mail Removed)...
> 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

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.



"Steve Schapel" wrote:

> 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "Rosemarie" <(E-Mail Removed)> wrote in message
> news:FB5C02FE-EB8C-432D-885E-(E-Mail Removed)...
> > 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
>
>
>