New User

[Uthaya]

Hi,

I'm a new user for excel and still using Excel 2003. I am trying to learn on
how to go about creating report with macro. As currently I have an office
assignment which has a exported report fro a different system i.e. Dataview -
Aspect on staff performance. I'm required to transer the data into excel.

Please assist

 

[Fred Smith]

The easiest way to learn macros is as follows:

1. Turn on Macro Record (Tools>Macros>Record Macro).
2. Do the task manually
3. Stop Reording.

Now Excel has created your macro, which you can make changes to. Post back
when you've done this and need help on specific parts of the macro. There's
a specific group for macros (excel.programming).

Regards,
Fred.

 

[Uthaya]

Hi There,

Appreciate your help on this. Will try out and let ya know the outcome.

Uthaya

 

[Uthaya]

Hi Fred,

The actual problem that i'm facing
- the report that is being extracted from the system is not aligned.
- the 2 different queue in which the agent value are shown however i need to
merge this 2 values. The values are in the form of no's (to add) & time (not
sure on how to go about this).

So how do I go about this?
Would be very grateful if can get assistance on this.
Uthaya

 

[Fred Smith]

1. To align numbers, use Format Cells. Right click on the cell, choose
Format Cells...>Alignment, and choose the alignment you want.
2. Times are just numbers. You can add them like any other number, as in
=a1+b1

If you need more help, post back with specific questions, and examples of
the results you want.

Regards,
Fred.