StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUsing VBA macro to take scraped data and create tables based on certain values
text
Body
copied!<p>I admit I am completely new to Excel VBA. At the moment, I am in charge of generating a summary of data based of an automatically generated table of data spit out on a site. I already figured out how to scrape the data onto my Excel thankfully.</p> <p>The scraped data is something of the following format:</p> <p><strong>TYPE | Number_Days_Logged | (a bunch of other important columns of data in row (6-7 items)|</strong> </p> <p>What I need to do now is the following.</p> <p>I need to do an if statement or comparison. There are two "types" under the type column. Let's say 0 and 1. I really only need type '1', so I need to filter out any 'type' 0's. Then I need to check the "number_days_logged". If this number is <= 1, I need to add it to a table with other entries with this condition. I then need to check "number_days_logged" for entries >= 85 and <100. These results will need to be put into a second table. Finally, I need to do the same this for values >= 100.</p> <p>So in the end I need three different tables, the first with a green color formatting, then orange, and finally red. Each table need to be titled with the above information, though I really only need data from specific columns in each row. (each row is labeled, I just need a specific few columns)</p> <p>This seems incredibly complicated to me, but I am willing to learn. If anyone can prod me in the correct direction, or make it simpler I would appreciate it. I can add any other details as required.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload