Auto Numbering a Tag name

Hello all

I would like to know if there is a way to Auto number a text.
I have a column with text tags (lets say Column B). These cells look at a specific cell (ex. A1) and see what text is written in it then copy the text into their own cells B1, B2, B3 and so on. So if cell A1 reports AAA then Column B cells become AAA all the way down.
Now what I like to do is for column B cells look at A1, copy the text and add _01 infront of their copied text. so for Column B, B1 reports AAA_01, B2 is AAA_02, B3 is AAA_03 and so on

What code should I use to do this?

Cheers

ADSK

Sure! If you are starting in Row 1, then the formula would be

Please Login or Register  to view this content.

If it's not starting in Row 1, then subtract the appropriate number from ROW()as necessary to get the proper results.

ChemistB

Thank you both.

Ok few problems;

=A1&"-"&ROW()
This code looks at the Row Number and uses the row number infront of the text. I like to have _01, _02 regardless of what the row number is.


=IF(A1="","",A1&"_"&TEXT(COUNTA($A$1:A1),"00"))
This one works except it reports all cells as the same number. is there a way I can make it look for existing number then generate a new number? for example if I used AAA_01 in cell B1, then next tsxt uses AAA_02?

ADSK

If A1 = AAA then B1 equals AAA_01
then if A2 = AAA then B2 equals AAA_02
or
if A1 = AAA then B1 equals AAA_01
If A3 = AAA then B3 equals AAA_02

Yes it works the way you said, but my problem is that all cells in column B look at only A1. I do not have A2 or A3.
All cells look at A1, copy its text to their cells and add _01, _02 infront of their copied text. I amsorry that Ididn't explain it properly.

ADSK

Hmmm, I'm confused.

It looks like VBA's formula does what you want. (Mine would work only if there are no blank spaces). Can you give a short example of what would be in column A and what you would expect in Column B? The example you gave so far seems to indicate that all the values in Column A would be identical (AAA).

ChemistB

Sure,

Here is a screen shot of what I need. I have 2 sheets side by side. Some notes are added and are in Red.

Thank you