Where To Begin Turning My Idea Into A Script? Dataset Manipulation

[brazen234]

prototype.jpg

I'm interested in a general understanding of how to start to go about this. What script commands I will be using, what the structure of the script is most likely to look like. I will try to work out the details when I have a better understanding.

From the image:
Compare G2 to G3, G4 etc... G2 and G3 same therefore run script to manipulate data in this set then output results as needed (will be to one row). Once complete compare G4 to G5, G6 etc... G4 and G5 same therefore run script to manipulate data in this set then output results as needed.
Etc, etc, etc...

Thx in advance!

[brazen234]

Bumping with additional info.

I have a feeling this won't be easy and there will be somekind of looping - each dataset is isolated from the other data and has it's own side script that manipulates the data how I want - the results are output and then the main script returns and keeps going to the next dataset. Can anyone get me on the right track? I don't mind spending time on educating myself on vba but I'm trying to avoid wasting time on things that won't be part of the solution.

[brazen234]

Bump...

I hope my question isn't too vague. I guess what I'm looking for is how to go about with the nested decision structures - I assume I'll need at least one or two "for loops" and some If/Then statements. But if I use a "for loop" on the G column then I would somehow need to isolate all the rows that have the same value consecutively in the column and then run another nested structure to work on that data. Am I on the right track? Will it be pretty complex?

[shg]

I've read all three of your posts and don't have a glimmer of a clue as to what you're trying to do.

[brazen234]

Is the image I attached showing up? Let me try one more time and I'll move on if it's still not clear.

The G column in the image has cells with values of "fail" and "pass". I'd like to be able to have the script check these cells. So in the image G2 and G3 are both "fail", G4 is not. Therefore the script creates a range (or dataset - not sure what the right terminology is) out of A2:F3 which can then be analyzed/manipulated and once analyzed the output is sent to another worksheet. The script will then move on to checking G4 against G5, G6. Since G4 and G5 are both "pass" and G6 is not, the script creates a range out of A4:F5. And so on. The values in G column will be random.

I'm not sure how to nest all this and what the general decision structure is going to look like. I suppose I will be using a bunch of "for loops" and if/then/else statements but I don't know enough about excel vba to be sure.

[scottiex]

What manipulation will you be doing to the data? that could be relevant to giving you the best solution.

anyway this is a loop for you you need to put some action in it of course!

Please Login or Register  to view this content.

[brazen234]

Thx for the example! The manipulation of the range data may itself include a loop and if/then/else statement or two. One specific thing would be checking the highest and lowest integers in the range - and depending on what row/column they are in - I would output the results differently. Also any arithmetic would be part of working with the data in the range. If I can get an understanding of the general structure that the script will take I can whittle down into the details. I'm thinking this project may take easily 20 hours - and the more I can pinpoint what I need to study in vba the more time I can save. It may turn out that my only option is to hunker down and to really learn about vba or even hire someone to do this - so that's part of what I'm trying to figure out.

[scottiex]

Well you can use
WorksheetFunction.Max() and WorksheetFunction.Min()

and then put that into WorksheetFunction.Match() to use the excel functions
eg

Please Login or Register  to view this content.

"a" of course being your range.

I imagine you can ask a series of specific questions on the forum as they come up and we can help.