Assign Numbers to Products - VBA HELP!

[M_S]

Hello,

I'm trying to assign numbers to different Products using VBA. For example, if in "Products" column product "REG_AA" appears I want to assign it a number, if it doesn't appear I want to assign the next item in the list the number and go in series. If the product "REG_AA" didn't show up on the list I would assign EXP_AA the number "1". Thanks!

Invoice Grouping	Products
1	REG_AA
1	REG_AA
1	REG_AA
2	EXP_AA
2	EXP_AA
3	REG_CA
3	REG_CA
3	REG_CA

 

[Crystalyzer]

where is the list?

 

[Fluff]

In what way is this different to your other thread?

 

[Fluff]

Duplicate to: Excel VBA Help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.