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

The easiest way to learn macros is as follows:

1. Turn on Macro Record (ToolsMacrosRecord 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" wrote in message
...
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

Hi There,

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

Uthaya

"Fred Smith" wrote:

The easiest way to learn macros is as follows:

1. Turn on Macro Record (ToolsMacrosRecord 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" wrote in message
...
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

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.

"Uthaya" wrote in message
...
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" wrote:

The easiest way to learn macros is as follows:

1. Turn on Macro Record (ToolsMacrosRecord 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" wrote in message
...
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