Hi Pam
Use the Sort and Filter, Filter command to sort with, and sort again
after adding to your list. You can only alphabetise one page at a time.
Paul
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Pamela
Sent: Monday, 5 March 2012 4:26 AM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Newbie to group and Excel
Hi, I'm Pa'm am in Ks and I need help with Excel Starter 2010. I'm new
to this and what to make a spreadsheet to inventory cartridge I have. I
would like to have 2 colums per page and have the ability to alphabetize
the lists. Since I will be adding more carts in time, I also need the
ability to add to list and then realphabetize it. Maybe abe able to go
from one page to another and have the pages alphabetize through all
pages.
Can anyone help?
Pam
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar