Rotating unique groups with no repeat

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.

Contact Oscar

You can contact me through this webpage


Time sheet for work

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.

Contact Oscar

You can contact me through this webpage


Extract cell references from a formula

One Response to “Extract cell references from a formula”

  1. Oscar says:

    I managed to simplify the regular expression to this:
    '?([a-zA-Z0-9\s\[\]\.])*'?!?\$?[A-Z]+\$?[0-9]+(:\$?[A-Z]+\$?[0-9]+)?

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.

Contact Oscar

You can contact me through this webpage


Filter rows where a cell contains a numeric value

4 Responses to “Filter rows where a cell contains a numeric value”

  1. John says:

    Hello Oscar
    I place lots of pictures in word 2016 files. As a person reads the report, I would like a button in the line to open a picture. The picture would relate to the text that was just read. Like you did with Excel (Show / Hide). It would be great if I could change the pictures with ease. Could you write this program? What would be the cost?
    John

  2. SACHIN says:

    Dear Oscar,
    I Need solution to get summary of days on which the specific leaves have been taken by an employee. Suppose on Ist and 2nd day he availed two casual leaves so summary of days should be come up like 1,2(days) in same row and same applicable for Present days, Festival Holidays.

    1 2 3 4 5 6 7 CL FH P
    CL CL P P P NH NH 1,2 14,15,16 3,4,5,

    Would be grateful to you.

    Warm Regards
    SACHIN

  3. Abbasabdulla says:

    Hello Oscar, Honestly you are one of the most skilful, intelligent people in excel/vba field. You have unique way of teaching others and communicating knowledge. Simply you awesome. Thank you very much. I am regular reader of your site and I find it very useful learning resource.

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.

Contact Oscar

You can contact me through this webpage


Like Operator

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.

Contact Oscar

You can contact me through this webpage