Rogue Diabetic
New Member
- Joined
- Mar 11, 2004
- Messages
- 15
I have been collecting live music and have come up with a storage solution for all the live cd's I've been burning that I think I could use excel to make easy.
I am relatively new to macros, and it would take me a ton of time to start from scratch with this, so I'm humbly asking for someone to point me in the right direction/offer some assistance with getting me started.
Here is my attempt at describing my idea:
I want to have a worksheet with a standard list of of the attributes of each live CD I have. These would include things like artist, date, show name, lineage, quality of the sound, venue, city, state, etc.. Then I want to take these attributes and have them thrown into the next worksheet into a "template" that I will be able to print up and stick in the sleeve I'll be storing the cd in (I can provide an example of this template that I have manually typed in excel).
I can describe how I think it will work but I need help starting out on this.
I will start on the main list page (where my big list will be of each bootleg).
I would like to save each new entry in a its row as I do it too, so the info is never lost, just added to each time I add another show.
So, I will click a button and the macro will start. It will ask me to type in the info for each attribute along the various columns, and when I type it in (say, the artist name), the macro will throw the attribute into the proper column, then I hit "ok" and it asks me for the next attribute. I will have a new row with all the info in it once that macro is done running.
Then, on the "template" worksheet there will be a button that says "create info sheet" or something, and upon clicking, it takes you back to the list of shows, asks you which column to pull all the data from, and you click the column the show's data is in (so techinically I could print the data for any show in my list at any time, not just the last one on the list), and then the macro will take each item of data from the columns and place the letters/numbers in the template in their appropriate places in the template.
I think this would not be too difficult, but I just need a start, and I'm hoping this is the kind of thing some knowledgeable person could whip up (bare-bones even) in 5 minutes. I have looked around on this forum and seen the help pages, but I read about visual basic and editing and feel frustrated. I have made changes to macros before but never started one from scratch.
I hope I am not going about this in too much of the wrong way. If anyone could offer some help (write some simple code so I can see it and I could definitely modify it from there) or just point me to some code that I can get and modify myself, or any kind of help would be appreciated. Thank you for reading my lengthy post. I have lots of live music to offer someone a little something in return if that would be appropriate.
Regards,
Travis
I am relatively new to macros, and it would take me a ton of time to start from scratch with this, so I'm humbly asking for someone to point me in the right direction/offer some assistance with getting me started.
Here is my attempt at describing my idea:
I want to have a worksheet with a standard list of of the attributes of each live CD I have. These would include things like artist, date, show name, lineage, quality of the sound, venue, city, state, etc.. Then I want to take these attributes and have them thrown into the next worksheet into a "template" that I will be able to print up and stick in the sleeve I'll be storing the cd in (I can provide an example of this template that I have manually typed in excel).
I can describe how I think it will work but I need help starting out on this.
I will start on the main list page (where my big list will be of each bootleg).
I would like to save each new entry in a its row as I do it too, so the info is never lost, just added to each time I add another show.
So, I will click a button and the macro will start. It will ask me to type in the info for each attribute along the various columns, and when I type it in (say, the artist name), the macro will throw the attribute into the proper column, then I hit "ok" and it asks me for the next attribute. I will have a new row with all the info in it once that macro is done running.
Then, on the "template" worksheet there will be a button that says "create info sheet" or something, and upon clicking, it takes you back to the list of shows, asks you which column to pull all the data from, and you click the column the show's data is in (so techinically I could print the data for any show in my list at any time, not just the last one on the list), and then the macro will take each item of data from the columns and place the letters/numbers in the template in their appropriate places in the template.
I think this would not be too difficult, but I just need a start, and I'm hoping this is the kind of thing some knowledgeable person could whip up (bare-bones even) in 5 minutes. I have looked around on this forum and seen the help pages, but I read about visual basic and editing and feel frustrated. I have made changes to macros before but never started one from scratch.
I hope I am not going about this in too much of the wrong way. If anyone could offer some help (write some simple code so I can see it and I could definitely modify it from there) or just point me to some code that I can get and modify myself, or any kind of help would be appreciated. Thank you for reading my lengthy post. I have lots of live music to offer someone a little something in return if that would be appropriate.
Regards,
Travis