A method for doing what I think you want to do is pretty simple. I've seen it done using a macro (Someone else will need to help you with the macro coding. I'm not good enough yet to do it off the top of my head.)
What you want the macro to do is when the user clicks the button, the value of the active cell is read, 1 is added to it, and the results are placed back in the activecell location. One thing I've messed with and it may just be overkill is I keep a running total somewhere away from where the user is working and use it to help validate the information the user sees.
I hope this helps.
Quote:
|
Originally Posted by A.R.J Allan Jefferys
,Hello Again
Could i get some help with this.
How does one get an activecell , that has a value of 1, that is copied from
sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
on how many times I copy a sheet.
I hope this makes sense
Thanks in Advance
Allan
|