You posted this in general questions. Stick to one thread and don't
multi-post, it wastes the freely given time of those who respond not knowing
you already have responses

Mike H

"pwk" wrote:

I have a spread sheet that has: Item: 0308 0730 in cell A24, Item:
0308 0763 in cell A39 and so forth, I would like to put a 1 in cell
AB24, 2 in AB39 and so forth. I could probably base my macro on
Finding the text "Item" and Sequentially Numbering in the allied colum
AB. I've tried using find and search functions to no avail. I know
this is probably easy using a fuction or FindNext but I'm also having
a problem Sequentially Numbering. THANKS in Advance. Paul