Macintosh Excel macro

Program will upload this type basic directory from Windows or Macintosh. Contractor talent will provide a working sample of this program. No payments will be made to any person that cannot guarantee working script. We will want to use this software to confirm functionality. A $250 deposit will be made and total amount paid to the contractor after we have title. Contractor will have documents providing clear direction for the work. We want this program to have successful upgrades. Other professionals should have an easy time reading. 1 Selling Person is Office [login to view URL] The left of this workbook is the correct parsing columns. [login to view URL] Please have the program export a .CSV such as this. Sample Upload_Listing_23-Feb-2020 02 42 [login to view URL] Basic reference. We want all the information on these pages. The images show only some of the information. We want ALL of it. You have already been given the column names. SAMPLE Office Manager [login to view URL] SAMPLE Selling [login to view URL] SAMPLE Selling Person [login to view URL] .CSV export should have columns with automatic format width to fit information. Finder 'Preview' will have the same. Finder 'Preview' will also show all the same information as the content inside the .CSV document. Example. Finder 'Preview' Screen Shot 2020-02-24 at 6.24.52 [login to view URL] _______ How the macro works. .HTM is given to the Excel macro and automatically a .CSV exports to a location in the computer. The documents in the directory for upload do not have name requirements. Each upload has. Two easily recognizable pages. 1_ GSMLS [login to view URL] [login to view URL] For this explanation we will call these pages, ‘House’ and ‘Selling Person profile’. Each upload has categorically. 'House' page. (.HTM) 'Office Manager' page. (.HTM) ...one or two (1-2) 'Selling Person' page. (.HTM) BOTH the ‘Office Manager’ and ‘Selling Person’ profile pages are visibly the same. Some uploads will have ‘House’ page and ‘Office Manager’ is the ‘Selling Person’. Example. 1 Selling Person is Office [login to view URL] (Two pages) Some uploads will have ‘House’ page and ‘Office Manager’ and one ‘Selling Person’. Example. 1 One Selling Person and Office [login to view URL] Some uploads will have ‘House’ page and ‘Office Manager’ and ’Selling Person’ 1 Example. 1 Two Selling People Broker Selling [login to view URL] Some uploads will have ‘House’ page and the ‘Office Manager’ is one of the two selling people. When the Office Manager is found to be a selling person, they will be under the ’Selling Person’ 1 and the ‘Office Manager’ category. ‘Selling Person’ 2 will be the other Selling Person Profile in the directory. Example. 1 Two Selling People Broker Selling [login to view URL] Some uploads will have ‘House’ page and ‘Office Manager’ and two separate selling people. Example. 1 Two Selling People and Office [login to view URL] Some uploads will have mistakes. There are times when the user includes duplicate .HTM documents in the directory for upload. These directories should have the macro provide a user notification describing what the error is and continue to parse correctly. Example. Duplicate Selling Person or Office Manager Profile, Upload Not [login to view URL]