Hi everyone,
This thread will have the same question/idea as my first one. Due to my own mistake, the macros I got were not suitable and it was advised to make a new thread with the new information added.
I wanted to make a results file for my team. Currently we are doing everything manually, and I think using macros will make our life easier.
So, the idea:
We will receive a request with a test list, we copy this list to the sheet called "Info" and specify how many samples we need to test.
What I would like to happen next:
This is what the "Info" sheet looks like:
This list currently continues to row 139, but can change every year.
Not all of these codes correspond to a test we perform(some are sample prep or belong to tests of a different team), so those will be hidden to shorten the list.
Next is the "Results" sheet:
As you can see, not all tests have a sheet.
Now to the reasons why the macros from my previous thread didn't do exactly what I wanted:
When there is more than 1 sample, the added rows will be separated by a line, I would like this to be a dotted line, see below.
In my original thread I didn't specify this and had a blank row which was a "workaround" for my own code.
The second mistake I made was quite big:
In my original thread, all tests only had the number of that test as their sheet-name. In reality they will have this number AND a shortened, easy to understand name. These names are not the same as the test name in the "Info" sheet or the "Results" sheet.
Also:
There are 2 sheets that should be visible when both OR either of the mentioned tests are marked in the "Info" sheet.
Hopefully this is enough info and someone can help me achieve what I have in mind!
I would like to learn from all of this (so I can be able to come up with something acceptable myself in the future), so if it is possible to explain some of the main parts of the code, that would be much appreciated!
-Melissa
This thread will have the same question/idea as my first one. Due to my own mistake, the macros I got were not suitable and it was advised to make a new thread with the new information added.
I wanted to make a results file for my team. Currently we are doing everything manually, and I think using macros will make our life easier.
So, the idea:
We will receive a request with a test list, we copy this list to the sheet called "Info" and specify how many samples we need to test.
What I would like to happen next:
- In the "Results" sheet, the correct amount of rows will be created, corresponding to the sample amount.
- The tests that are NOT marked by an X in the testlist will have their columns hidden and, if applicable, the sheets as well.
This is what the "Info" sheet looks like:
This list currently continues to row 139, but can change every year.
Not all of these codes correspond to a test we perform(some are sample prep or belong to tests of a different team), so those will be hidden to shorten the list.
Next is the "Results" sheet:
As you can see, not all tests have a sheet.
Now to the reasons why the macros from my previous thread didn't do exactly what I wanted:
When there is more than 1 sample, the added rows will be separated by a line, I would like this to be a dotted line, see below.
In my original thread I didn't specify this and had a blank row which was a "workaround" for my own code.
The second mistake I made was quite big:
In my original thread, all tests only had the number of that test as their sheet-name. In reality they will have this number AND a shortened, easy to understand name. These names are not the same as the test name in the "Info" sheet or the "Results" sheet.
Also:
There are 2 sheets that should be visible when both OR either of the mentioned tests are marked in the "Info" sheet.
Hopefully this is enough info and someone can help me achieve what I have in mind!
I would like to learn from all of this (so I can be able to come up with something acceptable myself in the future), so if it is possible to explain some of the main parts of the code, that would be much appreciated!
-Melissa
