Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Help
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 | +-------------------------------------------------------------------+ -- JPritch ------------------------------------------------------------------------ JPritch's Profile: http://www.excelforum.com/member.php...o&userid=29497 View this thread: http://www.excelforum.com/showthread...hreadid=564861 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Help
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 "JPritch" wrote: 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 | +-------------------------------------------------------------------+ -- JPritch ------------------------------------------------------------------------ JPritch's Profile: http://www.excelforum.com/member.php...o&userid=29497 View this thread: http://www.excelforum.com/showthread...hreadid=564861 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |