Hi can i autonumber in the field A/A when i type something in field code (I ATTACH THE FILE). Thnx
Hi can i autonumber in the field A/A when i type something in field code (I ATTACH THE FILE). Thnx
Hi nik,
Not entirely sure that this is what you want, but if you want a number generated in Column AA on the LIST-NCR TOTAL tab when you make an entry in Column Z, the following formula:
will do that for you. If you want the numbers to start at something other than 1, change the red 1 above to whatever number you want.![]()
Please Login or Register to view this content.
If I've misunderstood you, let me know.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
I want it for cell A and cell B but is ok . Thnx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks