Excel Macro
Budget: $30 – $250 AUD
A Excel Macro to perform a range of functions depending on column and rows selected.
Based on the sample file I want a Macro that does the following once I select any number of rows. It is very important that I can select exactly what rows I run the macro on. While the sample data looks simple the full data set will be far more complicated.
The Marco will place the calculated data on a new line at the bottom of the existing sheet each time it is run.
The calculation it will run on each column and place in new row:
Year=copy value of first selected row.
Name=copy value of first selected row.
Sold=SUM of selected rows.
Stakes Performers=SUM of selected rows.
Stakes Winners=SUM of selected rows.
Gr1 Winners=SUM of selected rows.
Average Price=AVG of selected rows, NO decimal places needed.
Sale Gross=SUM of selected rows, NO decimal places needed.
Based on the sample file I want a Macro that does the following once I select any number of rows. It is very important that I can select exactly what rows I run the macro on. While the sample data looks simple the full data set will be far more complicated.
The Marco will place the calculated data on a new line at the bottom of the existing sheet each time it is run.
The calculation it will run on each column and place in new row:
Year=copy value of first selected row.
Name=copy value of first selected row.
Sold=SUM of selected rows.
Stakes Performers=SUM of selected rows.
Stakes Winners=SUM of selected rows.
Gr1 Winners=SUM of selected rows.
Average Price=AVG of selected rows, NO decimal places needed.
Sale Gross=SUM of selected rows, NO decimal places needed.