Open Office Macro or Script

Not sure how to get this done, BUT I need something like a Macro in Open Office for a spreadsheet. The first tab in the attachment shows what the data will look like, the second tab shows what I want it to end up like.

The DATE column should be split into 2 columns (Appointment Date AND Appointment Time)

Any "= [Name]" after a phone number should be deleted

The rows should be sorted by STATUS and then any record with Client or Clinic Cancel should be deleted

PROVIDER/STATUS should be changed to PROVIDER

All columns AFTER Provider should be deleted

Keep in mind that the *.xls files will often be up to about 80 rows. This is just a sample.

Skills: Visual Basic

See more: open office macro, spreadsheet script, office macro, office 2013, xls visual basic, macro spreadsheet, clinic name, xls tab, open tab, open attachment, open office basic macro, macro time, macro open, script provider, phone number provider script, office open time, macro phone, appointment office, script office, open phone, office script, script macro, sample script xls, data xls script, visual basic macro script

About the Employer:
( 6 reviews ) Eugene, United States

Project ID: #5105701

Awarded to:


Download sample file here: [login to view URL] hi, im a professional programmer just starting out here in Im starting with small projects like this to get reviews. I have created a s More

$23 USD in 3 days
(1 Review)

8 freelancers are bidding on average $25 for this job


I have 8 yrs of Exp in VBA,VB6, and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start if you want i will also send Macro as per your input waiting for your feedback on sam More

$25 USD in 1 day
(12 Reviews)

hi Frank, it's very simple. Which OS are you using - WINDOWS ? or MAC ? Please reply and we can discuss further. thanks :-)

$23 USD in 2 days
(18 Reviews)

Hi, probably you're aware that openoffice does not support vba macros. I can write the macro for an excel spreadsheet, or can try to do it in openoffice with formulas only. Are any of these options acceptable to you?

$40 USD in 1 day
(5 Reviews)

hello, i had highly experience 10 years in vb6 + vba macros in all MS. office soft (2002 - 2013), OpenOffice Calc 3.5 and 4.0 i did later this month successfully "Created at run-time by macros code 500 Check-box More

$33 USD in 3 days
(2 Reviews)

A proposal has not yet been provided

$25 USD in 3 days
(0 Reviews)

I am conversant with Excel and I will be able to provide you sheet modified as desired by you,thatis,exactly as shown in the second sheet (tab).

$15 USD in 1 day
(0 Reviews)

Hello, I wrote this macro for you and I am ready to deliver it. I created one temporary sheet, put required data in it, delete original sheet, and renamed temporary sheet to have the same name as original sheet. It More

$15 USD in 0 days
(0 Reviews)