Copy filtered excel tables in vba


 

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Highlight a selected cell´s row and column


 

5 Responses to “Highlight a selected cell´s row and column”

  1. shimaa01234 says:

    Great job and is very useful
    Thank you very much Mr. (Oscar)

  2. mahmoudlee123 says:

    Work more than wonderful, because you are a wonderful person

  3. Manish says:

    Dear Oscar
    i want to highlight the row if checkbox in my customised menu is clicked.
    please help & provide code.

  4. Olvavila says:

    Dear Oscar

    In your first example Excel highlights all rows until last column (XFD). I need highlight from column A to column R. Is it possible?

    Thanks!

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Optimize pick path in a warehouse


 

One Response to “Optimize pick path in a warehouse”

  1. domain says:

    You're so interesting! I do not think I've truly read something
    like this before. So good to discover somebody with a few
    unique thoughts on this subject matter. Really..
    thanks for starting this up. This site is something that
    is required on the internet, someone with a little originality!

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Compare two lists and filter unique values where the sum in one column doesn’t match the other column


 

3 Responses to “Compare two lists and filter unique values where the sum in one column doesn’t match the other column”

  1. mahmoud-lee says:

    All formulas that belong to you wonderful

  2. Sean says:

    Thanks Oscar. Works great. Is there a way to include items that are not in list B in the same formulas. For example C would have avalueof 4 in list A, but it's not in list 2.

    • Oscar says:

      Sean,

      Thanks Oscar. Works great. Is there a way to include items that are not in list B in the same formulas. For example C would have a value of 4 in list A, but it's not in list 2.

      Array formula in cell B10:
      =IFERROR(INDEX($E$3:$E$7, MATCH(0, COUNTIFS($B$3:$B$7, $E$3:$E$7, $C$3:$C$7, $F$3:$F$7)+COUNTIF($B$9:B9, $E$3:$E$7), 0)), INDEX($B$3:$B$7, MATCH(0, COUNTIFS($E$3:$E$7, $B$3:$B$7, $F$3:$F$7, $C$3:$C$7)+COUNTIF($B$9:B9, $B$3:$B$7), 0)))

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

A quicker A * pathfinding algorithm


 

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file