Find Jobs
Hire Freelancers

Excel Macro to fix, change, add , remove data from spreadsheet

$30-250 USD

Completed
Posted about 8 years ago

$30-250 USD

Paid on delivery
I have an excel report from Peachtree software "[login to view URL]" that must be manipulated to become an exact format. The report will have different number of rows , so macro must sense how many rows are there and manipulate accordingly. 1. Change the column that has word "Check" to "I" (Left Justified) 2. Change date format from "3/3/16" to "03/03/2016" (Right Justified) 3. Remove Total row from bottom 4. Remove Underline, Double Underline from area where total was 5. Remove blank rows (Top and Bottom) [login to view URL] 2 columns on left side and insert Text data (Right justified ) I must be able to modify macro to change text data as needed. I will need to be able to replicate and modify macro for different reports 7, Remove duplicate rows.
Project ID: 9853839

About the project

6 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi Hiring Manager, I have read your job description and find that I am interested in this job. I have full knowledge of Excel, Word and web Research. I assure you that work will be done with full accuracy. I am looking forward to your positive reply. Thanks
$45 USD in 1 day
5.0 (1 review)
0.4
0.4
6 freelancers are bidding on average $76 USD for this job
User Avatar
HI I am an excel-vba Expert and I can finish your project so fast pm me I am ready to start now ..............................................................
$88 USD in 3 days
5.0 (26 reviews)
5.0
5.0
User Avatar
Iam ready for this job , iam certified please check my badges and profile , please contact me thanks a lot sir
$100 USD in 1 day
5.0 (1 review)
0.9
0.9
User Avatar
I have obtained six (6) years of accounting professional under my belt. I have been fixing my loopholes in the accounting system. I have had the privilege to work with clients to ensure that deadlines are met; developed awareness to changes within various industries such as government, for-profit and not-for profit; grasped the necessary information on any additional regulations and requirements to be report on the operation of each department, and directed to management through daily audits. I have examined and analyzed accounting records to determine financial status of each establishment; built relationship with clients through communication; and prepared financial reports concerning operating procedures. I have impeccable ability in building relationship with colleagues, supervisors, and managers. I am adept in working with any complex figures and formulas. I have mastered the use of Quickbooks, OAsys (payroll software), Microsoft Excel and the other Microsoft Office Suites. My ability to offer attention to details has helped in picking up errors instantly thereby saving time. With great analyzing, compiling and correctional skills, I maintain the audit record thick and clear. While maintain clear accounting standards, I double-check that the records are processed as per law and management's policies. This is why I am the best candidate for the job.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Yes... We can create a macro for your requirement.... Hi... I am ready to work on this project and let me know the details and have a discussion on your requirement... Thanks!!
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I review ur attachment as *****100% MILESTONE REQUIRED. Willing to work long-term. Samples cannot be uploaded as freelancer has no provision for attachments unless you don’t invite for project discussion***** Greetings dear client, Jasmine (BCA, M.Sc-IT), with an experience of over 5 years is ready to serve you. In my dealings you will find me as a hard working and a reliable service provider. Also check my profile on oDesk: jasmine19. Skills: • Content writing and re-writing- Articles (promotional & non-promotional) for websites and submissions, blogs, SEO based content and non-SEO based content • Website content writing • Press Releases (or PR) • Copywriting (punch lines, creatives, advertisements) • Proposal/Bid writing • Concept creation • Developing Power Point Presentations • News writing • Writing Journals and for magazines • Newspaper advertisement • Classified advertisement • Ghostwriting- ebooks, etc • Writing articles for tech niche like gadgets, mobiles, laptops, etc • Technical content writing • Product reviews/review writing I also own copyscape premium account. I can also write articles “optimized for keywords” (SEO based writings) as well as “writing for people” (not for Google). Expertise: Travel, Real Estate, Finance, Dating & Escorts Services, health/medical, fashion, tech niche, pets, DIY, How tos, generic niche as well. “STRICTLY NO SEX/PORNO NICHE” I am reachable via Gtalk, Skype, emails, phone calls, message boards. HIRE ME NOW!!! Regards, Sussane Jari
$35 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
4.9
7
Payment method verified
Member since Sep 4, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.