Help Setting Up Basic Excel Project...

  • Thread starter Thread starter woodman650
  • Start date Start date
W

woodman650

Hey all!
I took an Excel class years back and I remember that you can do this,
but I just don't remember how. I'd like to create a fairly simple
project. Basically, I have two columns: "title" and "author"
I then would like a button on the spreadsheet that opens up a dialogue
box that allows a user to add a new Title and Author, which when
"submitted" are added to the main spreadsheet and are automatically
alphabetized.

It doesn't sound that difficult, I just don't know how to create a
button (where to start). Any help would be greatly appreciated.
Thanks!

Woody S.
 
You can do the first by simply selecting the two columns and going to
Data>Form. This will give you a built-in form.

When done, select the two columns and Data>Sort. You can choose which column
to sort on.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Alright, but I mean, is there a way to create a little form embedded
into the worksheet? (So I don't have to open any menus). thanks
 
That is ten times as much work as using the built-in.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top