• MVP Logo
  • Recent Forum Posts

    Pecoflyer

    Please help!

    @cprop
    Hi
    in the future please a more descriptive thread title instead of " please help".
    Thanks...

    Pecoflyer Today, 05:24 PM Go to last post
    p45cal

    Please help!

    Aagh. Beaten to it!
    Power Query solution at cell H10.
    Update the data in the table at cell A1 then right-click the result table and choose...

    p45cal Today, 11:27 AM Go to last post
    alansidman

    Please help!

    A Power Query solution:

    Code:
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Unpivoted Columns"
    ...

    alansidman Today, 10:39 AM Go to last post
    cprop76

    Thanks, sample attached!

    Thanks, sorry for the VERY late reply, I've been out of the office all week. I've attached a sample which hopefully makes sense! The left hand side is...

    cprop76 Today, 03:41 AM Go to last post
    p45cal

    Check cell format is Date ignore blank cells

    try:

    Click on the picture to get a clearer view.

    Oops, fotrgot the code:

    Code:
    Private Sub DateFormat()
    Dim myRange As Range
    ...

    p45cal Yesterday, 03:01 PM Go to last post