Numbering cell based on another cell. VBA?

P

pwk

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
 
P

pwk

Hi,

is there anything in the cells between A24 & A39?

Mike





- Show quoted text -
Click to expand...

Mike,

Yes, additional data relating to Item: 0308 0730. None with the text
"item"
 
M

Mike H

As noted in your other thread don't multi-post it wastes the time of those
who freely give their time to respond
 
P

pwk

As noted in your other thread don't multi-post it wastes the time of those
who freely give their time to respond





- Show quoted text -
Click to expand...

Sorry, I wasn't aware this was forbidden. Do you have a solution?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find text Sequentially Number 9
Dynamically reference a cell based on cell content 1
cell value based on another cells formula??? 7
Auto fill cell based upon another cell value 3
Changing Cell Background Color based on data from another cell 2
Bring back row and column value based on the number in a cell 0
Two formulas in on cell based on two numbers in another cell? 5
Populate Cell based on selected Cell. 2

Top