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.
8 freelancers are bidding on average $25 for this job
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?