Hope I can explain this so someone understands it.
I am trying to debug a MACRO created for a sales commission report.
In COL O is the Comm Rate.
NOTE: The Range in this Column varies from month to month. Last month when I initially recorded the macro this col had 178 rows. This month it's 228. With that in mind here's my dilemma:
The Comm Rate is listed as x.xxx.
A 1% rate is listed as 1.000.
A 1/2% rate is listed as 0.500.
I need to get it to read 0.010, .005, etc.
so I recorded the macro in P2 to read: O2*.01
Leaving the result as .010.
In my initial Macro I sent to the corner of P2 cell and dbl click to autofill to the end of the active spreadsheet.
Then I COPY the entire Col and Paste Values into COL "O" to correct all the data to the correct %. I then delete COL "P".
My problem. The Initial MACRO still wants to use O2:O178 as the AUTOFILL instead of O2:O228. Why?? How can I sneak around this problem?
Is there a way to reformat COL"O" so the data changes from 1.000 to .010? Tried everything I could think of. I thought the Autofill would change from month to month.
Desperately need someones help.
If you wish to call me use 800-536-3900 x154
ask for Mike.
If you need more information please ask.
Zac
I am trying to debug a MACRO created for a sales commission report.
In COL O is the Comm Rate.
NOTE: The Range in this Column varies from month to month. Last month when I initially recorded the macro this col had 178 rows. This month it's 228. With that in mind here's my dilemma:
The Comm Rate is listed as x.xxx.
A 1% rate is listed as 1.000.
A 1/2% rate is listed as 0.500.
I need to get it to read 0.010, .005, etc.
so I recorded the macro in P2 to read: O2*.01
Leaving the result as .010.
In my initial Macro I sent to the corner of P2 cell and dbl click to autofill to the end of the active spreadsheet.
Then I COPY the entire Col and Paste Values into COL "O" to correct all the data to the correct %. I then delete COL "P".
My problem. The Initial MACRO still wants to use O2:O178 as the AUTOFILL instead of O2:O228. Why?? How can I sneak around this problem?
Is there a way to reformat COL"O" so the data changes from 1.000 to .010? Tried everything I could think of. I thought the Autofill would change from month to month.
Desperately need someones help.
If you wish to call me use 800-536-3900 x154
ask for Mike.
If you need more information please ask.
Zac