We have to be careful in "assuming" that the terminology you are using means the same for us as it does for you.
To ME, what you said is that you want to select one of the cells in Column A and have a list of data in column B to change. there are many, many questions that arise. Where do you get the data to 'refresh' column B? What criteria do you use? do you know anything about VBA? first of all, in VBA it is possible to create "events". One event is called the "SelectionChange" event. In this event, you would test to see if the selected cell is in column "A", If it is, then you would use VBA to collect the info based on the selection and display it in column B. Without having more information, it really isn't possible to be any more help without giving you 1000 things that don't apply to what you're doing. Already I've made assumptions that may not apply. hope this helps. paul ________________________________ From: Ankit Mehra <ankitmehr...@gmail.com> To: excel-macros@googlegroups.com Sent: Wednesday, June 3, 2009 9:43:08 AM Subject: $$Excel-Macros$$ Help Required - Urgently Hello everyone, I am facing a problem and would appreciate your advise on the same. I have an excel file in which i have put Data Validation - List in one column (for example - Col A). Now, i want another list in the other column (for example 0 Col B) to be refreshed automatically whenever the selection is changed in Col A. This is very important as by doing this i would be able to save an ample time in my work. Thanks & Regards Ankit Mehra --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
