Hi Zannah
If all you want is an excel spreadsheet like a list of items arranged by
number then I would suggest you create it and then convert it to a table .
To do this click inside the list after you have a few items in it and then
go to the insert tab and click table. Then follow the prompt. This formats
the table and puts arrows on each item in the heading. You click these to
sort the table in ascending or descending order on that column.
Easier to try it than to describe it.
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of garilou
Sent: Friday, 8 July 2011 1:07 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Re: New Member: My first question please!
Hum,
Why don't you try first with a template:
http://office.microsoft.com/en-us/templates/CT010117254.aspx
There are lots of tenm!
Louise
--- In ExcelVBA@yahoogroups.com, "zannah_girl" <zannah_girl@...> wrote:
>
> My husband and I are venturing into a new business in which I'm going to
need to put our inventory on a spreadsheet. And it will need to be a
spreadsheet that I can add to as we fill our shop.
> I've had a basic excel class and still have my workbook, but this was like
10 years ago.
> So....My question: How difficult will the formula be, for a novice like
myself, to set up a spreadsheet in which each item needs to line up in
numerical order?
> I have more questions, but I'll just start with this one.
>
> Any help anyone can offer will be greatly appreciated!!!
>
> Thanks,
> Zannah
>
------------------------------------
----------------------------------
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
----------------------------------Yahoo! Groups Links
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