Help with a simple database

[dddave]

I am attempting to use Excel to develop a simple database for my office.
The database basically lists a variety of orders purchased from various
vendors, and my goal is to categorize and sort each vendor seperately.

For example:

GC Group 4/24/03 7831.1 $1,000.00
Alpha 1/20/03 7003.1 $2,000.00
Chandler 5/6/03 7050.1 $345.50

Is what the main chart looks like. Now, what I'm trying to accomplish
is, suppose I added

Tomsen 4/20/03 7873.1 $200.00

to the very bottom, Excel would automatically create a new tab (or even
worksheet, if possible) titled Tomsen with that information, and then
automatically sort (by date, I guess) whatever information was in the
Tomsen tab (or .xls).

I'm wondering if this is all that complicated to achieve, or not. If
someone could please answer a few questions, I'd greatly appreciate
it.

- Dave

 

[Dave Peterson]

Instead of automatically doing it, I think I'd have a macro that runs on
demand. (Then you don't have to worry about creating/updating incorrect sheets
if you make a typo.

And I'd steal as much as I could from Debra Dalgleish's site:

There are a couple of files here:

http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb