New to Excel - Need to pull info from multiple sheets into one master sheet

**aimacademy** · 09-24-2012, 01:14 PM

I have been asked to create a template for scoring NRA long range shooting matches. They would like the sheets to represent each shooter category while having an overall sheet to show all shooters in their order of finishing the match. The sorting will need to be done with 2 variables - the total score and in case of a tie the number of X ring hits. Example: 2 shooters scored 197 but shooter A has 18 X ring hits and shooter B has 17. I would appreciate any help you could give and I have attached the file I have created up to this point. Thanks again.Long Range Match Scoring Sheet Template.xlsx

**arlu1201** · 09-24-2012, 02:31 PM

Try this

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

**aimacademy** · 09-24-2012, 04:05 PM

Thank you very much Arlette. That worked like a charm. Is there a way to make the VB code run automatically every time one of the worksheets are edited? I only ask because the match director who will be using this template is not very computer friendly. Please don't take this as me being unappreciative of what you've done, I just want to be sure he will understand how to use it without having to have me hold his hand through it every week. Thank you again.

**arlu1201** · 09-25-2012, 04:10 AM

To make it easy for the person using your file, you can assign the code to a button which you can insert on your Overall page. Then you can have them edit any of the tabs and just click the button.
I have designed the macro in such a way that each time you press the button, it will clear the overall sheet (except the headers) and then populate the sheet with data from all the sheets all over again.

**aimacademy** · 09-27-2012, 09:38 AM

Hi Again Arlette. Our match directors liked your code so much they asked me to get another created with slightly different settings, that is if you don't mind helping again. I have attached the new workbook. This one will be similar to the other in the way that he would like the overall sheet to have the combination of all the sheets. This one only needs to sort by the lowest number. This type of competition is basically a timed event so the person who does it the fastest wins. I used the other workbook you had helped me with to begin this one. Again I very much appreciate your time and expertise. If you are ever in need of any web design or graphic design please let me know so I may repay your kindness.

3 Gun Match Scoring Sheet Template.xlsm

**aimacademy** · 09-27-2012, 09:49 AM

Hi Again Arlette. Our match directors liked your code so much they asked me to get another created with slightly different settings, that is if you don't mind helping again. I have attached the new workbook. This one will be similar to the other in the way that he would like the overall sheet to have the combination of all the sheets. This one only needs to sort by the lowest number. This type of competition is basically a timed event so the person who does it the fastest wins. I used the other workbook you had helped me with to begin this one. Again I very much appreciate your time and expertise. If you are ever in need of any web design or graphic design please let me know so I may repay your kindness.

Attachment 183223