Sorting information
I have master list on one sheet that I would like to sort into
different sheets based on one column of information. For example, if this particular column has a value of "blue" the entire row goes to one worksheet; if it has a value of "red" that row goes to another worksheet. Can Excel perform this function? And sort the subsequent worksheets in alphabetical order? Thanks. |
Sorting information
Look here at Ron de Bruin's site for code related to this:
http://www.rondebruin.nl/copy5.htm -- Regards, Tom Ogilvy "Maria" wrote: I have master list on one sheet that I would like to sort into different sheets based on one column of information. For example, if this particular column has a value of "blue" the entire row goes to one worksheet; if it has a value of "red" that row goes to another worksheet. Can Excel perform this function? And sort the subsequent worksheets in alphabetical order? Thanks. |
Sorting information
I checked out the site, but I really didn't understand it. I'm not
incredibly excel literate. I am very much in the learning stages. Unfortunately, I really need step-by-step instructions. I have no experience with macros, so I was thinking of using IF statements to sort them...Is this a good idea? Would a macro be easier? Any answers would be appreciated. Thanks. |
All times are GMT +1. The time now is 12:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com