Macintosh Excel macro

Kapalı İlan edilme: 4 yıl önce Teslim sırasında ödenir
Kapalı

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]

Excel VBA Excel Macros Mac OS

Proje NO: #24063498

Proje hakkında

6 teklif Uzak proje Aktif 3 yıl önce

Bu iş için 6 freelancer ortalamada $20/saat teklif veriyor

schoudhary1553

Hello, I can help you with your project - Macintosh Excel macro I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several p Daha Fazla

$20 USD / saat tutarından itibaren
(25 Değerlendirme)
5.4
zekovicm

Hi there,I am Excel Macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the Daha Fazla

$25 USD / saat tutarından itibaren
(1 Yorum)
3.7
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects i Daha Fazla

$20 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
ssuet123

Hey there, Hope you are doing fine. I have been doing work in Microsoft scripting, VBA, formulas, graphs and dashboard creation using pivots, for the past 5 years. I can do this job perfectly for you if you share more Daha Fazla

$20 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
azizayoubi

Hello, I am Aziz Ayoubi, MS Excel and Access expert with more than 7 years experience, and 3 years with Google Sheets, VBA, Google Script and C# programmer and IT troubleshooting master. I read your requirements caref Daha Fazla

$15 USD / saat tutarından itibaren
(1 Yorum)
0.0
Pkdhiman003

Hello sir Relevant Skills and Experience We have no skil

$22 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0