Numbering cell based on another cell. VBA?

  • Thread starter Thread starter pwk
  • Start date Start date
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
 
As noted in your other thread don't multi-post it wastes the time of those
who freely give their time to respond
 
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
Calculations based on cell colour 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Summary based on highlighted cells 4
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Two formulas in on cell based on two numbers in another cell? 5
number columns skip blanks 4

Back
Top