Store Value and Shift down cell value

[chucklesOU]

Hey guys, I'm writing a code to count and store values to reference how often something is referenced in a class. I'm trying to write a code that counts with one button (this is complete) and stores historical values in another column. This is where I'm having issues. My counter is set in B2, and I have F2:F200 set aside for value storage. I'd like a button to automatically store the value from B2 to the next available F column cell and automatically reset B2 to 0. Is this possible? Thanks

 

[Joe4]

Welcome to the Board!

I think it would be most helpful if we could see an example of what your data looks like and an example of your expected output.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[chucklesOU]

Welcome to the Board!

I think it would be most helpful if we could see an example of what your data looks like and an example of your expected output.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Hi Joe4, thanks for the quick reply! There is no data to work with yet, so that's quite difficult to do. Here's the best way I can explain it:
My professor mentions Fish Fingers every class. As a fun side project, I wanted to have a button to count, in integers, how many times he says this.
For every time I press the button, it adds 1 to B2.
The problem I'm having is not knowing how to write the second part of the program:
I want a button to store the value from B2 at the end of class, and place it in the F column automatically before resetting B2 to for next class. When the value is stored in the F column, the next class should automatically have the new value stored directly underneath the previous class's final value.
I hope this helps!

 

[Joe4]

Try this:

Sub AddTotal()
    Cells(Rows.Count, "F").End(xlUp).Offset(1, 0).Value = Range("B2").Value
    Range("B2").Value = 0
End Sub

 

[chucklesOU]

Try this:

Sub AddTotal()
    Cells(Rows.Count, "F").End(xlUp).Offset(1, 0).Value = Range("B2").Value
    Range("B2").Value = 0
End Sub

Sorry for the delay, tested this in class today and it worked perfectly! Thanks!

 

[Joe4]

You are welcome!