Enter data in a cell to make a list on another sheet

[tah2x]

Hello to all!

I am new to this site and need some help. I have a cd collection that I would like to input into excel. I would like to type in the Artist, Album Title, Songs, etc. in a cell or a row. Then I would like the information typed in to be put into a list on a different sheet.

Can this be done? I am not an expert by any means on excel, so please if there is an example you can show me, that would be very helpful.

I have other ideas for using this type of formula, but will start small.

Thanks for your help!

[jraj1106]

Hello!

Can you give all the details that you want to feed into the sheet? Artist,Album Title, Songs. That's all or do you want some more data to be fed into the sheet?

Pls specify..

[tah2x]

I don't know just yet, but would like the Artist, Album Title, Song Title, and potentially could add in song number, length of song, genre and potentially any other referencing data. I think if I can keep it simple with just the artist, album and song for now, it may be enough for me to work with to figure out how it is done. I may try to use the worksheet as a data base so I could look up information or sort through the data in the future.

Does that help?

[jraj1106]

Try this. I have a form which will help you to insert the details into a list format.

Please Login or Register  to view this content.

[tah2x]

That worked well, thank you.

I don't know much about macros, but as I learn more about them, then I should be able to move the ADD CD INFO box to another location in the worksheet and will also be able to add other criteria such as song length or whatever. I figure I can then create another worksheet for movies or books.

I appreciate your help. Thanks so much!

[jraj1106]

Yes, you can add any number of details on to that sheet using the form.

Please click on the star below. Thanks!

[tah2x]

What did you name the macro? Thanks!

[jraj1106]

Its not a macro. But I have a button on sheet1 called "Add". When you click that you will have a form wherein you will be adding all the details. Later you click on the "ADD" button on that form and the details that you had filled in the form comes on to the sheet. The code is in sub cmdadd_Click().

[tah2x]

I see. So if I wanted to add to the form to include let's say the song number, how would I do that? Also, how can I move the button into column A and move the columns so the Artist column is column C and the remaining info is to the right of column C? Does that make sense? Just wondering how to edit this sheet.

Thank you!

[jraj1106]

Go to the code window and click on the forms folder. you will see the form named "userform1". Double click on that and the form will be opened in design mode. You can insert the necessary controls and modify the look of your form.


Check this:

Please Login or Register  to view this content.