• MVP Logo
  • Recent Forum Posts

    Beddy Boy

    Formulae / LOOKUP help

    Thank you for the response.

    Please see file.

    Please let me know if you need anymore info....

    Beddy Boy Today, 01:41 AM Go to last post
    p45cal

    Formulae / LOOKUP help

    Save us time and attach a workbook with the first table in, making it as true-to-life as you can without revealing sensitive data....

    p45cal Today, 01:16 AM Go to last post
    Bob Phillips

    Looking for Excel formula

    This array formula should do it.

    =IF($A3"",SUM(B3:INDEX($B$1:$B$20,MIN(MIN(IF($A4:$A$20"",ROW($A4:$A$20)-1,99^99),ROWS($A$1:$A$20))))),"")...

    Bob Phillips Yesterday, 11:26 PM Go to last post
    tzaharia

    Tabs To Share or Data Reference Update

    The Hide and Protect tabs works to a point. The problem being if they create a new worksheet, they are able to unprotect and unhide the other sheets....

    tzaharia Yesterday, 07:20 PM Go to last post
    tzaharia

    Macro to Share Workbook Through Email

    So I am setting up a parent (Source) workbook which will have tabs dedicated to each client we have. Each client will have their own child(Destination)...

    tzaharia Yesterday, 06:58 PM Go to last post