Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro active sheet
I have two worksheet. the second worksheet name "Financial" had one cell
link to first worksheet name FC_Rank when the user select a factor on the first worksheet that factor name link to cell A3 on the second sheet (=Financial!!A4) this name will lookup the data and put in the correct format. My question How can have a Macro when the user click the second worksheet (FC_Rank tab) the format will change immediatley to the format i want? Example 1 : sale $ CY PY Chg to PY % Inc/dec $100.00 $75.00 $25.00 33.3 % % $456.00 500.00 -$44.00 11.23% Example 2 Gas Gallon CY PY Chg to PY % Inc/dec 1000.00 950.00 50.00 5.25% Thanks Liem |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro active sheet
Rather than using a macro, why not manually format the second sheet the way
you want? Then leave it thay way. If you insist on using a macro, the easiest way is to turn on macro recording, make the changes you want, then turn off recording and save the macro. Regards, Fred "liem" wrote in message ... I have two worksheet. the second worksheet name "Financial" had one cell link to first worksheet name FC_Rank when the user select a factor on the first worksheet that factor name link to cell A3 on the second sheet (=Financial!!A4) this name will lookup the data and put in the correct format. My question How can have a Macro when the user click the second worksheet (FC_Rank tab) the format will change immediatley to the format i want? Example 1 : sale $ CY PY Chg to PY % Inc/dec $100.00 $75.00 $25.00 33.3 % % $456.00 500.00 -$44.00 11.23% Example 2 Gas Gallon CY PY Chg to PY % Inc/dec 1000.00 950.00 50.00 5.25% Thanks Liem |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
list sheet names vertically below the active cell - need macro. | Excel Worksheet Functions | |||
copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
Macro to run on the "Active Sheet" | Excel Discussion (Misc queries) | |||
How to change macro so it performs actions on ACTIVE sheet? | Excel Discussion (Misc queries) |