Extract Information to another worksheet

[Woo]

Hi,
I have a worksheet listing training (one row per training session) that was
done and then have columns with an "x" under each person who participated in
that training.

I need to create a means to summarize each persons' training over a certain
time frame (training date is one of the columns), only pulling the rows where
that person has an "x" for participation at a training session. Several
columns from each row would need to be copied to the new worksheet in order
to summarize the training that was attended.

I'd appreciate any advice.

 

[Ronald Dodge]

This is something that pretty much would be better suited to write out a VBA
code for, which I'm not sure how much knowledge of VBA you have, if any.
Many times, when I am doing quick and dirty type work, I will use formulas
to do the work for me, but if it involves recursive type actions such as in
this situation, it looks to be that sort of deal, I'll generally go ahead
and write out a macro in VBA to address the issue.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

 

[Woo]

Hi Ronald,

I don't have much knowledge of VBA, is it something I can figure out myself,
or is there some sort of training I can take to learn it? I think that I
could make use of this feature.

Thanks.

 

[Ronald Dodge]

I'm not sure what your training budget is, but one thing you can do is use
the "Macro Recorder" to help you get started in the learning process. Once
you have recorded, and you start looking at the code, you probably will
start to notice how VBA works to some extent. To get to the code, you can
press "Alt-F11" or you can go through the Tool menu. Executrain does have a
2 day training course on VBA that covers things like the various general
stuff of how to work in the VBA environment such as looking things up and
how to debug for the different types of errors, but yet, it doesn't get into
the deeper levels of the codes nor does it get into good programming
practices.

One warning about the macro recorder, once you start seeing how it works,
you will also need to learn how to edit the code, which will come over time.

Once you learn enough of the VBA stuff, I'm sure you will find a lot of uses
for it.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

 

[Wendy]

Thanks Ronald.

Wendy

I'm not sure what your training budget is, but one thing you can do is use
the "Macro Recorder" to help you get started in the learning process. Once
you have recorded, and you start looking at the code, you probably will
start to notice how VBA works to some extent. To get to the code, you can
press "Alt-F11" or you can go through the Tool menu. Executrain does have a
2 day training course on VBA that covers things like the various general
stuff of how to work in the VBA environment such as looking things up and
how to debug for the different types of errors, but yet, it doesn't get into
the deeper levels of the codes nor does it get into good programming
practices.

One warning about the macro recorder, once you start seeing how it works,
you will also need to learn how to edit the code, which will come over time.

Once you learn enough of the VBA stuff, I'm sure you will find a lot of uses
for it.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000