• MVP Logo
  • Recent Forum Posts

    AliGW

    Split workbooks by a column value

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query...

    AliGW Today, 01:29 PM Go to last post
    mmoore5553

    Help to automate excel spreadsheet

    I need to automate having a list of users and adding certain verbiage and taking in the variable names. I was going to use mail merge but i need it...

    mmoore5553 Today, 08:47 AM Go to last post
    aravindkm

    Split workbooks by a column value

    Hi Gurus,

    Need Your help i have spreadsheet with around 20 columns i need a code to split it based on the Column A (clusters) and save the...

    aravindkm Today, 06:13 AM Go to last post
    GregT

    Print button macro

    Hi all,

    I have a workbook with 4 sheets - 2 are hidden. The following code I am using works with the hidden sheet.

    The problem...

    GregT Yesterday, 03:06 PM Go to last post
    p45cal

    If a date falls on a uk holiday date

    Test this in cell B4:

    Code:
    =IF(WORKDAY.INTL(A4-1,1,"0000000",$B$2)A4,A4+2,A4)
    copied down.
    Currently it looks at cell B2 for the holiday, but...

    p45cal Yesterday, 01:15 AM Go to last post