Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Once sections are loaded (which may take up to 30 minutes) , click ‘Michelle’s Super Secret Export’ in the top right.

    • Both the sections search and export can be run in the background while you are doing other tasks

    • The export may take 30-45 mins minutes to load

  • Once the export is complete, open the Excel file.

  • Click on the upper left box to highlight ALL data, then double-click on the edge of the first column A to auto-adjust all of the columns

  • Add a filter to the first row (the headings)

  • Go to the ‘Last Updated’ Column X and click on the filter

    • Deselect all of the data so that all check boxes are blank

  • Drill down on the current month by click the ‘+’ sign

  • Select all of the dates from the previous week including today

    • Example: If I’m running the export on 8/

      12

      8/

      2021

      2024 I would select 2,3,4,5,6,

      9,10,11,12

      7,8

...

  • Scroll back to top of the sheet and save the file as

    • “BMS Updates as of X.XX.XXXX”

    • Be sure to save as excel not CSV (.xlsx)