Previous Topic Next Topic

Macro Help Needed

Closed
LRS - Jul 9, 2010 at 02:36 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 13, 2010 at 07:05 AM
Hello,

I need a macro that will calculate complaint rates against sales,
and the apply that macro against sales for x number of monthly sales,
ex. the last 13 months, or the last 3 months, or some variable of the number of months.

I don' t know anything about Macros so any help would be greatly appreciated.

3 responses

Answer 1 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 9, 2010 at 04:44 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0
Answer 2 / 3
LRS
Jul 12, 2010 at 11:18 AM
I've uploaded my file here for viewing.
https://authentification.site/files/23348411/ALL_SALES_HISTORY_TEST.xls
0
Answer 3 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 13, 2010 at 07:05 AM
Could you explain your data and how it pertains to your problem
0

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses