Re: $$Excel-Macros$$ Patron List

2009-11-15 Thread Dilip Pandey
Dear Tommy, One thing you can do here is to use key combination CTRL + Down Arrow to go to the last record of the column and then use CTRL + SHIFT + HOME to select the data - Note this will select the data only till freeze line and by this way you can skip the data which are lying above from the f

Re: $$Excel-Macros$$ Patron List

2009-11-14 Thread Dilip Pandey
Hi, If the list is in Excel, then you can use below two options as per your choice:- 1) Use Pivot Table, put the Names in Row column and the count of the names in data field, sort the data as ascending and you have the names in alphabetcal oder and their count in the next column. 2) If you just

$$Excel-Macros$$ Patron List

2009-11-14 Thread Tommy
I am developing a ticket managing program for a community choir and now have generated an extensive list of ticket purchasers by name, where some names are repeated many times over due to multiple purchases by the same person. I would like to generate an alphabetized list by name, a patron list, w