Excel Macro Help

J

JPritch

Hi all...I have a spreadsheet macro created by IT here in my company
that takes a daily text extract and allows me to pivot that data into a
more user friendly excel format.

There are some formatting issues I wanted addressed, but nobody seems
to be able to figure it out. So I've attached the macro and text file
in the hopes that one of you here might be able to work your magic!

1) If you run the macro and see the resulting output, the "Status
Color" field is displayed in the following order: Green, Orange, Red,
Yellow. I would like them displayed as: Green, Yellow, Orange, Red.

2) For some reason, only the Green cell is filled with the color green.
I would like to be able to make the other cells show their
corresponding colors.

If somebody could help me out I would really appreciate it.


+-------------------------------------------------------------------+
|Filename: Copy of SPIA_Pivotemacro.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5096 |
+-------------------------------------------------------------------+
 
J

Jonathan

Hi, you are not able to post items with attachments.

Try recording a macro with the format effect that you want and then compare
the recorded macro with the existing macro. Maybe in viewing the difference
you can spot the solution...

Jonathan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top