Hi
I have 3 columns
Gender
Name
Email
I want to create two lists to the side of my data which lists peoples email addresses according to their gender.
I know how to sort this just the once by it is constantly being updated so need a formula to add them to the other list as they are updated.
Can anyone help
Thanks
Excel formula to sort email list?
No VBA required to do AutoSort
You can do sort using formulas (like ROW, OFFSET, INDIRECT)
here is a lesson on how to do that
http://file1.net/lesson.asp?id=9
and here is another one
http://file1.net/lesson.asp?id=10
And this is the file for that lesson
http://file1.net/project.asp?id=70
You may need to modify that file with Dynamic names to include the new added rows
search for dynamic in http://www.file1.net to see how you can do that
After all, VBAXLMan is here to feed your Excel needs
Reply:you'll need VBA script to have it automatically update. good luck - that's not an easy thing to learn.
seriously, you can't do that without VBA.
you could try and record yourself updating it manually into a macro and run it and see if that works. It probably won't but you could try it.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment