• MVP Logo
  • Recent Forum Posts

    glennm0270

    Excel Refresh All Stopped Working

    Sometime in the last week or so, the Data / Refresh All action stopped working in Excel on one of my Windows machines. I click Data / Refresh All (or...

    glennm0270 Today, 06:56 PM Go to last post
    Madjry

    Keeping excel formating in email body

    The email created does not keep the formatting from Excel.
    I know you can add HTML code to keep the formatting in the email body.

    How...

    Madjry Today, 04:25 PM Go to last post
    ArdusPetus

    extract data from web

    The form is a POST form, not a GET one.
    Your request should be like this:

    Code:
        
    With oXMLH        
        .Open "POST",
    ...

    ArdusPetus Today, 03:41 PM Go to last post
    NormS

    Pivot table

    Your source data is already pivoted. Rearranging it into Month and Values columns will give you what you're looking for....

    NormS 2020-04-04, 11:01 PM Go to last post
    NormS

    If , vlookup and drop down list

    Is this what you are trying to do? I've used INDEX/MATCH to do the equivalent of a VLOOKUP, along with INDIRECT to select the correct column in the price...

    NormS 2020-04-04, 07:04 PM Go to last post