Quote:
Originally Posted by Spencer101
Have a look at the attached for a cut down version of what you're trying to do.
Let me know if it doesn't make sense or you need more help.
S.
|
That's very neat Spencer. On quick question though, this phone number is in a pre-populated list of information already. Has customer name, address, phone etc. I need to be able to drop code in the (STATE ABBV) cell that auto fills the state abbreviation all the way down after pasting the info into excel. So using the drop down might not work. Example :
John S. Smith | 123 Any St. | Anytown | (123) 234-4567 | (STATE ABBV)
John D. Smith | 123 Any St. | Anytown | (123) 234-4567 | (STATE ABBV)
John A. Smith | 123 Any St. | Anytown | (123) 234-4567 | (STATE ABBV)
John V. Smith | 123 Any St. | Anytown | (123) 234-4567 | (STATE ABBV)
*REPEAT 1,000's of Times*
The "|" character represents a new cell in Excel.
Please see the attached example. Thanks!!!!!!