Hi
Can anyone tell me how to do this :-

From :

Empty Locations
U-Sites:
U1H1, U3B2, U5C1
U7C1, U7E1
Q-Sites:
Q1D1, Q1D3

To :

Empty Location U1H1
Empty Location U3B2
Empty Location U5C1
Empty Location U7C1
Empty Location U7E1
Empty Location Q1D1
Empty Location Q1D3


Using VBA.

Thanks.


---
Message posted from http://www.ExcelForum.com/