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/