Hello everyone
I have two sheets .. Sheets("INF") and Sheets("List")
I need to put a code in worksheet activate event in List sheet ...every time I activate the List sheet ,range("E1") would increase by one till specific number (according to criteria)
The criteria would be the value of range("B8") in Sheets("INF")
If sheets("INF").range("B8")="Pre" then >> when activating sheets("List") ,range("E1") would be 1 for the first visit ..if I activate another sheet then activate Sheets("List") the range ("E1") would be increased again by one so the new value would be 2 .. then again if I deacativate the List sheet and activate it again the value of range ("E1") would be 3 and this is the end point ...if activated List sheet again the value would be 1 again ..
In other words >>my target is to increase sheets("List").range("E1")
If sheets("INF").range("B8")="Pre" so the changes would be between 1 to 3 only
If sheets("INF").range("B8")="Pri" so the changes would be between 1 to 6 only
Hope it is clear
Bookmarks