Em Andamento

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.

Habilidades: Visual Basic

Ver mais: open office macro, spreadsheet script, 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, script spreadsheet

Acerca do Empregador:
( 6 comentários ) Eugene, United States

ID do Projeto: #5105701

Premiar a:

gamboy214

Download sample file here: http://jmp.sh/v/xcTCqA1QX3RJfLp19w3B hi, im a professional programmer just starting out here in freelancer.com. Im starting with small projects like this to get reviews. I have created a s Mais

$23 USD em 3 dias
(1 Comentário)
1.1

8 freelancers estão ofertando em média $25 para este trabalho

piyushdpatel

I have 8 yrs of Exp in VBA,VB6,VB.net 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 Mais

$25 USD em 1 dia
(12 Comentários)
4.8
expertatwork

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 dias
(18 Comentários)
3.9
zExcel

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 em 1 dia
(5 Comentários)
3.3
logoDS761

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 Mais

$33 USD in 3 dias
(2 Comentários)
2.2
wentie425

A proposal has not yet been provided

$25 USD in 3 dias
(0 Comentários)
0.0
teeares

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 em 1 dia
(0 Comentários)
0.0
NikolaTx

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 Mais

$15 USD in 0 dias
(0 Comentários)
0.0