[TW.87]

I am using Microsoft Excel 2003 to keep a detailed catalogue of my DVD collection.

As it is, I have a row per DVD, with multiple columns of information used to catalogue further information on the DVD.

What I would like to do is to have some type of a function where by an automatic numbering occurs everytime I add a new DVD. Essentially, all I want is the "numbered list" feature from Microsoft Word to let me know how many DVD's I have.

Also, because my list is sorted alphabetically, if I add a new DVD that begins with "H", I need the numbered list to automatically update (once again as it would in Microsoft Word).

So, the first cell on each row is where I want to display the DVD number (so, '23' would be the twenty-third DVD of the collection).

If anyone can offer any help on how I can achieve this, I would greatly appreciate it.

 

[Rollin_Again]

The task you are doing would be ideal for MS Access instead of Excel. Is there any particular reason why you chose Excel? If you insist on using Excel, I would recommend creating a user form that would allow you to easily into the record data via a graphical interface. A simple click of a button on the form would insert the new row of data and sort the data automatically for you. Does this sound like something that would interest you? Please attach your sample workbook to your next post so that we may see the layout of your data and provide sample solutions.

Regards,
Rollin

 

[OBP]

I agree with Rollin, this would be easier to achieve in Access, and importing from Excel is very easy.
I have a DVD collection database that I am working on for someone else that you can use if you like, although it is for an extensive DVD collection with track and artist details.

 

[The Villan]

I wouldnt mind that OBP

 

[OBP]

I will remove the current data and put a copy on here, unless you want me to leave some so that you can see how it works?
It has an Import facility for when DVDs are created, which you might not want.

 

[The Villan]

Thanks

A few records would help just to get the feel of it.

The import facilty - does it read the Cd or something and come up with all the detail instead of having to type it in ?

 

[The Villan]

>>The import facilty - does it read the Cd or something and come up with all the detail instead of having to type it in ?
<<

me being a lazy git and liking anything that doesn't require data input

 

[OBP]

No the database doesn't do that, but the guy that I am writing it for has a program that does that and creates an Access table which the import routine appends to the table.
The program is called DIRPrinter and it is free.

 

[The Villan]

Now that sounds more like it.

So presumably you put the Cd into the DVD/CD drive and this program then reads all the necessary info and then converts it for Accesss use?

 

[TW.87]

Thank you for the great replies everyone.

I'm quite happy to use whatever program is easier to achieve what I want, so I will start looking at using Microsoft Access instead.

If that file can be posted so I can get an understanding of how it works (I am unfamiliar with Microsoft Access, although have it installed), I would greatly appreciate it.

Thank you again for your help!

 

[OBP]

Tanna, the program doesn't currently do what you want to do in Excel, but it shouldn't need to.
If you are totally unfamiliar with Access you may need some instruction on how to move around records.
Do you know how Combo Boxes work?
I will leave a few records in the database so that you can see how it works, if you like it I can Import your data from your Excel sheet for you.
I have removed 63 of the DVDs from the Tables, each DVD holds 5 to 10 CDs.
The database has to be "Unzipped" to work.

 

[The Villan]

That looks good OBP

I will have to convert it a bit to suit my requirements.

Thanks

 

[OBP]

Let me know if you want or need any help.

 

[The Villan]

I should be OK, but will only be able to have a go at it in Feb as I have too many other committments at the moment.
However if I get stuck I will come back.
Thanks

 

[TW.87]

Thank you for taking the time to post that file.

I'll have a look through it (I just had a quick look, but it's quite extensive, so I'll give it more time tomorrow), and get back to you if there are any questions.

Thank you again for your help!

 

[RootbeaR]

Are your rows not numbered in excel?

 

[exegete]

Going back to Excel, since you have XL 2003, it has extend List capability, so if your Column A has the first couple of numbers, then when you add something in the next empty row (not in Column A), it should automatically number that row in Column A.

Or am I missing something?