Hey everyone. I'm kindof a new Excel user. I've used some of the formula within excel itself to do some stuff, but I'm not really all that good. I found out about some functionality that Excel has (or probably has?) and I was hoping I could get some advice or pointers from more experienced people with Excel.
I am attempting to create a workbook that is tracking information for a gaming group. I am trying to do the following:
In a single workbook, titled ‘Character Tracker,’ I have three worksheets at the beginning. Sheet 1 is titled MAIN, Sheet 2 is titled LIST and Sheet 3 is titled MASTER. MAIN will be where all information is put in and referenced from/to. LIST will have a list in the A column of every sheet that is created. MASTER will have a template for individual storage, with cells defined to give data into a print area that is formatted, and prints a character sheet. LIST is easy, no problems there, with manual creation of new tabs. I have all of the stuff working for the MASTER sheet, with getting the print area and formatting working and referencing the data from the cells elsewhere in the MASTER sheet. This wasn’t hard at all, since it didn’t involve really any VBA. The problems I’m having are all having to do with the MAIN sheet.
On MAIN, I need to do the following:
* Create a drop-down box at the top that pulls from the range AllSheets in LIST. If there is not a matching sheet name listed, it will then create a copy of MASTER and name it whatever was entered into the box. This name will then be added to AllSheets in LIST. (IE: I choose BAXTER, and it loads the cells from BAXTER. I type in ANDREW, and it copies MASTER and renames it ANDREW as a new tab/worksheet, and adds ANDREW to AllSheets in LIST).
* If the name exists in the drop-down box, then in cells defined below, pull all the data from the MASTER copy named in AllSheets in LIST. (IE: Choosing BAXTER grabs the information from the BAXTER sheet, putting them in appropriately-defined (or numerically-noted) cells on MAIN).
* Those cells need to be able to have new data (it’s either basic text or numbers from 1 to 5) put into them; this data change then needs to be reflected the appropriate sheet name chosen in the drop-down menu above. (IE: I choose sheet BAXTER, and change the Strength field from 2 to 3 in MAIN. BAXTER then needs to have the Strength field changed from 2 to 3).
Any ideas or advice to get this type of stuff done would be helpful. :
Thanks in advance!
I am attempting to create a workbook that is tracking information for a gaming group. I am trying to do the following:
In a single workbook, titled ‘Character Tracker,’ I have three worksheets at the beginning. Sheet 1 is titled MAIN, Sheet 2 is titled LIST and Sheet 3 is titled MASTER. MAIN will be where all information is put in and referenced from/to. LIST will have a list in the A column of every sheet that is created. MASTER will have a template for individual storage, with cells defined to give data into a print area that is formatted, and prints a character sheet. LIST is easy, no problems there, with manual creation of new tabs. I have all of the stuff working for the MASTER sheet, with getting the print area and formatting working and referencing the data from the cells elsewhere in the MASTER sheet. This wasn’t hard at all, since it didn’t involve really any VBA. The problems I’m having are all having to do with the MAIN sheet.
On MAIN, I need to do the following:
* Create a drop-down box at the top that pulls from the range AllSheets in LIST. If there is not a matching sheet name listed, it will then create a copy of MASTER and name it whatever was entered into the box. This name will then be added to AllSheets in LIST. (IE: I choose BAXTER, and it loads the cells from BAXTER. I type in ANDREW, and it copies MASTER and renames it ANDREW as a new tab/worksheet, and adds ANDREW to AllSheets in LIST).
* If the name exists in the drop-down box, then in cells defined below, pull all the data from the MASTER copy named in AllSheets in LIST. (IE: Choosing BAXTER grabs the information from the BAXTER sheet, putting them in appropriately-defined (or numerically-noted) cells on MAIN).
* Those cells need to be able to have new data (it’s either basic text or numbers from 1 to 5) put into them; this data change then needs to be reflected the appropriate sheet name chosen in the drop-down menu above. (IE: I choose sheet BAXTER, and change the Strength field from 2 to 3 in MAIN. BAXTER then needs to have the Strength field changed from 2 to 3).
Any ideas or advice to get this type of stuff done would be helpful. :
Thanks in advance!