Frankenstein's script

**Metrazal** · 09-29-2014, 08:37 AM

Ok, I have a script that I pieced together and much like Frankenstein's Monster it is not behaving the way I want it to. The main issue I have is data is not always transfered to some of my sheets. Specifically, even when an "x" is in a row in columns L, M, N, or P the information I want copied to a sheet is not. Any help or guidance would be appreciated.

Thanks,

Met

Please Login or Register  to view this content.

**AB33** · 09-29-2014, 09:13 AM

Met,
Monster is understatement.
Please note I have not tested the code and some of the if statement are duplicates or wrong.
This is merely to show you it can be done with ifs statements.
If I were, I would have split the code in to 2-3 codes.

Please Login or Register  to view this content.

**romperstomper** · 09-29-2014, 09:23 AM

Are you sure the cells contain "x" and not "X"? Your tests are case sensitive.

**Metrazal** · 09-29-2014, 03:48 PM

Thanks ofr everyones help and guidance.

AB33: I followed your suggestions and it did help cleanup the script somewhat.

romperstomper: The "case" was not the issue but your suggestion made me look back at the data to be copied and I discovered that the script was copying the data but the data was blank. (Doh!)

Thanks again,

Met