Quote:
Originally Posted by JPP
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!!!!!!
|
Could you provide an example workbook? Either here or to the email address I provided.
You can use dummy data to anonymise it but the setup of your workbook will make it quicker to give you a working solution.