Help Needed with big spreadsheet


New Member
Oct 9, 2008
I am new to VBA

I am designing a spreadsheet that is used in sports It has a list of players names down a columns with the different skills going across in rows divided in to halves Attack and Defence It has 16 players and 10 skills in Attacks section and 16 Players and 11 Skills In the Defence section.
at the intersection of the column and the rows etc Player's Name and Different Skill is a command button that when pushed total 1 to the contents of a cell in a different worksheet that changes workheets dependent of the setting of 1 of 2 toggleswitches etc 1st period of play and so on.

Altogether the are 338 Commands Buttons that act as a counter for each skill for each players. There is 2366 lines of code and Everthing is working well.

Now I want to create a log of the command bottons that are pushed It stores on another worksheet and on that worksheet there will be 5 columns of data dependent on which command button is pushed.

I can do it once and it stores the right data in the right sheet in the right column But I don't know how next time I push any command button I want to know how to index the rows

Etc I push the command button1 1 it counts 1 to the total under the skill and against the players name and stotres it on the right spreadsheet dependent on the toggle button

Now on the Log page I will look at a Cell called Set and store the number in that cell it stores what period of the game in another column and what phase of players Attack or Defence and in another column it stores the players name and in the final column it stores what skill.

Next time I push any command button I want it to store the same type of data the name and skill will change with the command button pushed but how to index the row like a dataform but 338 enter buttons

Help please
Last edited:

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...