Search:

b_rad_1983,

How are you importing it?

If you are using VBA then the amount of data should not matter if coded properly. However, it can take some tweaking.

If you are using formulas or...

I was a bit sloppy when writing the first response. The formula should have been:
IF(AND(K3="Home",M3="W"),"W","")

i.e. just change the "L" to "" or 0 or whatever you want it to be.

I don't...

Create four new columns, "Home Win", "Home Lose", "Road Win" and "Road Lose"

For column "Home Win" set the formula to (assuming you have data in row 3):
IF(AND(K3="Home",M3="W"),"W","L")

That...

Sounds like you have calculations set to manual (xlCalculationManual) which it should be to make the code run faster. If that is the issue, insert the word Calculate after the web data has been...

To count highlighted cells, the following code works for me

Once the code has been added to a module, each function can either be used as a regular Excel function in a spreadsheet cell or as a...

Assuming the structure of the sheet is the same as the one I made, rather than counting each cell that is green, count the cells that meet the condition that makes the cell highlight green. I added...

Well, it got a bit more complicated than I thought but I have attached my crack at it. The key is to enter the conditional formatting using the formula option like in the link below.
...

The workbook I attached has the easiest solution I could think of. However, it might be too inflexible for your needs but there are always many ways to accomplish the same thing in Excel.

Rather...

Glad you got it working.

Try this and see if it works for you

Sub CopyValues()

Dim rngLastCell As Range

Dim rngCopyRangeFirst As Range
Dim rngCopyRangeLast As Range
Dim rngCopyRange As Range
Dim iCopyCount As...

Are you looking to do it using VBA code or using regular formulas? I have attached a workbook that does what your description says using formulas but it is very possible that I misunderstood what you...

Could you upload an example workbook where the cell result can't be used the way you want it. From your description, it should definitely be possible.