Hi all,
Anyone knows the easy way to add a consecutive number in "B" column as soon as data its entering in "C" column?
I have a file that it is use to track open and close cases. Sometimes the cases are closed in a different time frame comparing when the cases were open. We assign a consecutive number so we can keep track of the ticket. When the case is closed we cut the row and move it to another tab inside the excel file. There are plenty of cases and and many cases close that we do not know what is the next consecutive number that need to be assigned to the new case
Any idea how to solve this small issue?
Thanks
Alex
Anyone knows the easy way to add a consecutive number in "B" column as soon as data its entering in "C" column?
I have a file that it is use to track open and close cases. Sometimes the cases are closed in a different time frame comparing when the cases were open. We assign a consecutive number so we can keep track of the ticket. When the case is closed we cut the row and move it to another tab inside the excel file. There are plenty of cases and and many cases close that we do not know what is the next consecutive number that need to be assigned to the new case
Any idea how to solve this small issue?
Thanks
Alex