G
GoBrowns!
I have never written a macro in Excel, and I need big-time help.
I need a macro that will take the following fields from one worksheet:
Date
Average SORT Score
Average SET IN ORDER Score
Average SHINE Score
Average STANDARDIZE Score
Average SUSTAIN Score
Average TOTAL Score
Then, I need the macro to place these fields in a new worksheet in a
horizontal table.
Once that is complete, I would like for a macro to clear the initial
worksheet, then allow me to re-run the first macro so that I can have the
same fields placed onto the second worksheet under the data that has already
collected there. In short, I want my second worksheet to look like this:
DATE SORT SET IN ORDER SHINE STANDARDIZE SUSTAIN TOTAL
Jan 09
Feb 09
Mar 09
And so on, with all data points filled in.
Is this possible? And if so, how the heck do I go about doing it?
I am willing to provide any and all needed additional information. THANKS SO
MUCH FOR YOUR HELP!!!!
I need a macro that will take the following fields from one worksheet:
Date
Average SORT Score
Average SET IN ORDER Score
Average SHINE Score
Average STANDARDIZE Score
Average SUSTAIN Score
Average TOTAL Score
Then, I need the macro to place these fields in a new worksheet in a
horizontal table.
Once that is complete, I would like for a macro to clear the initial
worksheet, then allow me to re-run the first macro so that I can have the
same fields placed onto the second worksheet under the data that has already
collected there. In short, I want my second worksheet to look like this:
DATE SORT SET IN ORDER SHINE STANDARDIZE SUSTAIN TOTAL
Jan 09
Feb 09
Mar 09
And so on, with all data points filled in.
Is this possible? And if so, how the heck do I go about doing it?
I am willing to provide any and all needed additional information. THANKS SO
MUCH FOR YOUR HELP!!!!