Newbie VBA Help Needed!
Just start learning excel and VBA and encounter a problem. Thanks in
advance for all the help. Heres the situation. The sheet has a col A that looks like the following: Col A A B C C A D E B A D Is there a way (function or VBA) besides using advanced filter to filter the whole column (include blank cells), pull the distinct values and put them into another range of cells, which looks like this: New Col A B C D E <-- no need to sort Once again, thanks a lot for all your input and help!! Really appreciate it. Rex -- Disco ------------------------------------------------------------------------ Disco's Profile: http://www.exceltip.com/forum/member...nfo&userid=144 View this thread: http://www.exceltip.com/forum/showth...hreadid=112168 |
Newbie VBA Help Needed!
datafilteradvanced filterunique values only
"Disco" wrote in message ... Just start learning excel and VBA and encounter a problem. Thanks in advance for all the help. Heres the situation. The sheet has a col A that looks like the following: Col A A B C C A D E B A D Is there a way (function or VBA) besides using advanced filter to filter the whole column (include blank cells), pull the distinct values and put them into another range of cells, which looks like this: New Col A B C D E <-- no need to sort Once again, thanks a lot for all your input and help!! Really appreciate it. Rex -- Disco ------------------------------------------------------------------------ Disco's Profile: http://www.exceltip.com/forum/member...nfo&userid=144 View this thread: http://www.exceltip.com/forum/showth...hreadid=112168 |
All times are GMT +1. The time now is 11:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com