[why put xxx in col E?]
Larry
This isn't progrmming help, but on the sheet,
if your entries are scattered in cols B-D,
put =HLOOKUP("zz",B1:D1,1,TRUE) in col A
D-C Dave

LarryW wrote:
What I have is scattered cells entries. Each row has an entry I want in a
specific new column. I am working with 'Excel 2003' and don't know squat
about programing. I have tried filtering and do seem lost at this point to
consolidate all this data in cells to a specific column. Can anyone advise
me on how, step by step?


----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----