How to: Turn Summary sheet into individual detailed sheets?

I am assuming that the final workbook will only contain the "Summary Checksheet" and "Single Checksheet Template". You wish to have the individual worksheets created within the code.

Please Login or Register  to view this content.

Note: Due to the nature of your layout there is a variety of things that can go wrong. A lot of this can be fixed with error checking, which unfortunately takes a bit of time and testing to code in. I encourage you to learn how the code works and why it does what it does so that you can put in error checking and/or understand if things go haywire.

Note2: Double check everything as there was a lot of hand programming. Very tedious and prone to mistakes.

stnkynts, I will try this out first thing in the morning. Thank you for your BIG HELP!

stnkynts, it's almost there. There are a few things that came up.

1) What is the pop-up window in the beginning of the macro for?

2) On Structure number 7, on my upload, it is a pass. On your macro, it is a fail. The conditions for that specific scenario on the summary checksheet is the following: First there is a Pass, then there are 2 line items checked off for field conditions.

3) For Structure number 6, I have a note that on my upload it shows, but not on the macro. For coding purposes, do you want me to give it a code just like the others ones (like IFTS, NCAD, CMD, etc.)?

Let me know what you think.

@daffodil. Thank you kind sir. I see now that J5, J6, and J9 come from the reference sheet.

@JPWRana. As daffodil pointed out, J5, J6, J9 come from the reference sheet. However, you indicated that the final product will not have the reference sheet in it and will instead be located in another workbook in another directory. This, to say the least, is a critical problem. In answer to your other questions:

1) What is the pop-up window in the beginning of the macro for?

It is a built in fail safe. As i indicated in my code you can remove it if you wish.

2) On Structure number 7, on my upload, it is a pass. On your macro, it is a fail. The conditions for that specific scenario on the summary checksheet is the following: First there is a Pass, then there are 2 line items checked off for field conditions.

Correction made in amended code by utilizing a boolean variable.

3) For Structure number 6, I have a note that on my upload it shows, but not on the macro. For coding purposes, do you want me to give it a code just like the others ones (like IFTS, NCAD, CMD, etc.)?

I arbitrarily assigned it the code QNR, which can be later altered in code to match your own code.

Let me know what you think.

I think this took me longer than I initially planned. Like I said, it is still prone to potential errors and I don't have the ambition at this moment to make it bullet proof.


Amended Code:

Please Login or Register  to view this content.