What I would like is under column "D" to be able to select one store number at a time from the data sort filter. What I would like to do is have a VLookUp in cell “I8” for the range of store numbers in column "D" and have the store name appear depending on what single store is shown while using the Data Sort Filter in cell “I8”.
So if I use the Data Filter in column D and only shows store #7 I would like the vlookup to recognize that and show the name in cell “I8”. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe