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

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

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

I looked through Data Validation and did not see anything that I could
implement. If there are other sugestions, they will be appreciated.

Robert

wrote:
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