counter for entries

[NinjaBear]

Hi
Is it possible to have a cell (say A1) to increase (1,2,3 etc) when values are entered in a table in another sheet?

Basically i would like it for highlighting revisions so the main sheet just displays the latest revision and you enter/view in more details on another sheet

hope that makes sense?

and thanks again for any help in advance

[jeffreybrown]

Yes it's possible, but this will have to be done via a macro. A formula will not be able to update a number on top of another number in a cell.

Can you give some more details?

What sheet...what cell...?

[Domski]

Hi,

Do you just want to count the number of entries in a table then? If not what exactly would trigger the revision count?

Dom

[NinjaBear]

i'll try and explain better if possible so bear with me

worksheet "revisions" column A will contain 1,2,3 etc (in rows to represent the revision), column B will have the details of the revision change and column C the date of change.

on the worksheet "user interface" i would like A1 just to display the latest revision and so it would detect? any entries/values made within "revisions" (column B and/or C) and know which row entry was made to corrispond with the revision number in column A

hope thats bit better/clearer

thanks

again

[jeffreybrown]

I'm still not 100% clear and also not sure if you need a formula or VBA. Well actually, the way I understand it could be done with both.

Look at the sample and on sheet User Interface the revision will show up in A1 using a formula.

Look at the Revision tab and enter another revision in the next empty cell and the User Interface sheet will update accordingly.

How does this work for you?

[NinjaBear]

yes that sounds like what im after

where do i start lol

thanks