PLEASE HELP!
I am trying to write a macro which will be used on multiple spread sheets in excel.
I need to rearrange the columns and it may be necessary to add column to.
certain columns will need extra digit added and a formula needs to be done too.
I think the best way to do this is an example:
How I receive the spread sheet -
Column A B C D E F
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This then need a micro to be applied so it has this set out -
Column A B C D E F G H
Rates Prefix Area Prefix Rate Type Area Name Billing Rate Billing Cycal Min Cost Lock type
(empty) (column A above (alway states (column B above) (column C above (always 1/1 (column C above ("No Lock" on all)
with two "0" international) divided by 6 with unless column with "000" added
added to front) "000" added so D has mexico to creat 7 didgits)
each 7 digits long) in field which
makes it 60/60)
It would be better if the reorganizer micro was separate from the formula and formate macro.
I would love it if someone could help me because the macro iv written just isn't working and I don't understand why
Thank you
I am trying to write a macro which will be used on multiple spread sheets in excel.
I need to rearrange the columns and it may be necessary to add column to.
certain columns will need extra digit added and a formula needs to be done too.
I think the best way to do this is an example:
How I receive the spread sheet -
Column A B C D E F
CODE | DESTINATION | AT USD ($) | DATE | STATUS | ROUTE |
7840 | ABKHAZIA | 0.0483 | 06/08/2013 | DECREASE | |
79407 | ABKHAZIA-MOBILE AMOBILE | 0.0488 | 06/08/2013 | DECREASE | |
79409 | ABKHAZIA-MOBILE AQUAFON | 0.0488 | 06/08/2013 | DECREASE | |
672 | AET ANTARCTICA | 0.9805 | 06/08/2013 | NO CHANGE | |
67212 | AET ANTARCTICA CASEY BASE | 0.9080 | 06/08/2013 | DECREASE |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This then need a micro to be applied so it has this set out -
Column A B C D E F G H
Rates Prefix Area Prefix Rate Type Area Name Billing Rate Billing Cycal Min Cost Lock type
(empty) (column A above (alway states (column B above) (column C above (always 1/1 (column C above ("No Lock" on all)
with two "0" international) divided by 6 with unless column with "000" added
added to front) "000" added so D has mexico to creat 7 didgits)
each 7 digits long) in field which
makes it 60/60)
It would be better if the reorganizer micro was separate from the formula and formate macro.
I would love it if someone could help me because the macro iv written just isn't working and I don't understand why
Thank you