|
cycling through code based on menu choices
I import electrical measurement data into a sheet run some conversion
and formatting macros on it. Then, split the data up for analysis, manually, based on three of the columns titles DCODE, CONFIG and JOB NUMBER. Recently I have developed code (with a lot of help here) to break the data out based on the CONFIG column. For example If the CONFIG of all the data is either A, B or C the code copies all the CONFIG "A" to a new sheet, titles the sheet appropriately, and adds some statistical calculations to the sheet. This occurs for each CONFIG so I have new worksheets A,B and C. I am currently duplicating the code to perform the same manipulation based on the DCODE and JOB NUMBER columns. The next step is to be able to use a menu to select items from each the three columns using dropdown menus of the selections available under the three columns. Such as CONFIG "A & C", DCODE "32" and JOB NUMBER "C354". The result would be a worksheet built based on the choices made. I'm assuming I can do this by cycling through the three breakout codes. My question is, assuming I have the menu setup correctly, what would a clean way to do this? Any suggestion of a good starting point or basic method to work from would be greatly appreciated. Pointers to examples of a similar process would be a bonus! Thanks Robert |
cycling through code based on menu choices
I'm thinking that perhaps some of the filtering or, more likely, Data
Validation using dependent lists, information provided at http://www.contextures.com/tiptech.html in the "D" section may be of some help to you. " wrote: I import electrical measurement data into a sheet run some conversion and formatting macros on it. Then, split the data up for analysis, manually, based on three of the columns titles DCODE, CONFIG and JOB NUMBER. Recently I have developed code (with a lot of help here) to break the data out based on the CONFIG column. For example If the CONFIG of all the data is either A, B or C the code copies all the CONFIG "A" to a new sheet, titles the sheet appropriately, and adds some statistical calculations to the sheet. This occurs for each CONFIG so I have new worksheets A,B and C. I am currently duplicating the code to perform the same manipulation based on the DCODE and JOB NUMBER columns. The next step is to be able to use a menu to select items from each the three columns using dropdown menus of the selections available under the three columns. Such as CONFIG "A & C", DCODE "32" and JOB NUMBER "C354". The result would be a worksheet built based on the choices made. I'm assuming I can do this by cycling through the three breakout codes. My question is, assuming I have the menu setup correctly, what would a clean way to do this? Any suggestion of a good starting point or basic method to work from would be greatly appreciated. Pointers to examples of a similar process would be a bonus! Thanks Robert |
cycling through code based on menu choices
Thanks J Ill be studying that tonight
JLatham (removethis) wrote: I'm thinking that perhaps some of the filtering or, more likely, Data Validation using dependent lists, information provided at http://www.contextures.com/tiptech.html in the "D" section may be of some help to you. " wrote: I import electrical measurement data into a sheet run some conversion and formatting macros on it. Then, split the data up for analysis, manually, based on three of the columns titles DCODE, CONFIG and JOB NUMBER. Recently I have developed code (with a lot of help here) to break the data out based on the CONFIG column. For example If the CONFIG of all the data is either A, B or C the code copies all the CONFIG "A" to a new sheet, titles the sheet appropriately, and adds some statistical calculations to the sheet. This occurs for each CONFIG so I have new worksheets A,B and C. I am currently duplicating the code to perform the same manipulation based on the DCODE and JOB NUMBER columns. The next step is to be able to use a menu to select items from each the three columns using dropdown menus of the selections available under the three columns. Such as CONFIG "A & C", DCODE "32" and JOB NUMBER "C354". The result would be a worksheet built based on the choices made. I'm assuming I can do this by cycling through the three breakout codes. My question is, assuming I have the menu setup correctly, what would a clean way to do this? Any suggestion of a good starting point or basic method to work from would be greatly appreciated. Pointers to examples of a similar process would be a bonus! Thanks Robert |
| All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com