knightfall
New Member
- Joined
- Oct 13, 2013
- Messages
- 27
I have an excel program where I must enter the name of the winning team in a cell and their score in another cell and the name of the losing team in a cell and their score in yet another cell.</SPAN>
I have the program set to manually calculate. I calculate 3 sheets one at a time. I have recorded a macro that does this for me.</SPAN>
<TBODY>
</TBODY>
Once this is done then I move to the next set of teams that I have on another sheet in the workbook. The number of games played can range anywhere of 1 to 50.</SPAN>
<TBODY>
</TBODY>
I am in need of a VBA program that would automatically insert and run all the games in the other spread sheet for me.</SPAN>
I have the program set to manually calculate. I calculate 3 sheets one at a time. I have recorded a macro that does this for me.</SPAN>
Enter name </SPAN></SPAN> | Enter score</SPAN></SPAN> | Enter name</SPAN></SPAN> | Enter Score</SPAN></SPAN> |
<TBODY>
</TBODY>
Once this is done then I move to the next set of teams that I have on another sheet in the workbook. The number of games played can range anywhere of 1 to 50.</SPAN>
Winner</SPAN></SPAN> | Score</SPAN></SPAN> | Loser</SPAN></SPAN> | Score</SPAN></SPAN> |
Name1</SPAN></SPAN> | 1</SPAN></SPAN> | Name2</SPAN></SPAN> | 0</SPAN></SPAN> |
Name2</SPAN></SPAN> | 2</SPAN></SPAN> | Name3</SPAN></SPAN> | 2</SPAN></SPAN> |
Name3</SPAN></SPAN> | 2</SPAN></SPAN> | Name4</SPAN></SPAN> | 1</SPAN></SPAN> |
Name4</SPAN></SPAN> | 1</SPAN></SPAN> | Name5</SPAN></SPAN> | 1</SPAN></SPAN> |
Name5</SPAN></SPAN> | 3</SPAN></SPAN> | Name6</SPAN></SPAN> | 3</SPAN></SPAN> |
Name6</SPAN></SPAN> | 4</SPAN></SPAN> | Name7</SPAN></SPAN> | 2</SPAN></SPAN> |
Name7</SPAN></SPAN> | 2</SPAN></SPAN> | Name8</SPAN></SPAN> | 1</SPAN></SPAN> |
Name8</SPAN></SPAN> | 1</SPAN></SPAN> | Name9</SPAN></SPAN> | 1</SPAN></SPAN> |
Name9</SPAN></SPAN> | 2</SPAN></SPAN> | Name1</SPAN></SPAN> | 1</SPAN></SPAN> |
Name10</SPAN></SPAN> | 3</SPAN></SPAN> | Name2</SPAN></SPAN> | 1</SPAN></SPAN> |
<TBODY>
</TBODY>
I am in need of a VBA program that would automatically insert and run all the games in the other spread sheet for me.</SPAN>