Boxxcar Beginner

  • Member since Apr 14th 2020
  • Last Activity:
Posts
11
Points
38
Profile Hits
77
  • How can I programatically rearrange the tab order. That can facilitate the process as the user moves thru different steps of the process.

  • Column headins in row 3:

    Date Listed Month Listed Date Sold Month Sold

    The last two populated rows , first four fields in my spreadsheet look like this:

    01/27/17 1-2017 2/28/20 2-2020
    02/24/16 2-2016 2/28/20 2-2020

    Formula in Month Listed and Month Sold: =IF(A1083="FF","",CONCATENATE(IF(A1083="","",MONTH(A1083)),"-",IF(A1083="","",YEAR(A1083))))

    Having trouble in Macro copying these formulas down into the next row down.