| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a macro to replace one line with a few new lines?
I have an Excel technical problem to split the cost between divisions. Please
help to create a macro to replace my manual process. e.g. I have the following data Division Cost General 100 Admin 150 If the Division is General, the cost need be split by Key 1, if it is Admin, split by Key 2, and the original lines will be replaced by three different lines Division A Division B Division C Key1 50% 30% 20% Key2 70% 0 30% the result: Division Cost Division A 50 Division B 30 Division C 20 Division A 105 Division B 0 Division C 45 Please help! Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to insert blank line when lines sum to zero | Excel Discussion (Misc queries) | |||
| macro for fixed color lines in line chart based on series name | Charts and Charting in Excel | |||
| How do I create a macro that will automatically input lines? | Setting up and Configuration of Excel | |||
| 10 000 Line, every 2 Lines need a border and a open line inbet. e. | Excel Discussion (Misc queries) | |||
| How do I create vertical lines in a line chart? | Charts and Charting in Excel | |||
Threaded Mode
