Build a macro in Microsoft Excel
$30-250 AUD
Dibayar saat pengiriman
Build a macro that will do the following:
Select date columns (columns J & O) right click and format as Date - DD/MM/YYYY
Select Contract-No Column C – format as a number, no decimal places, no comma
separator
Select Revenue Columns K-M and Q-S right click and format as a number, 2 decimal
places, no comma separator
If any fields are blank in the following columns – copy from the column as indicated (this
applies if you choose to import practice fees and allowances noted at the end of the
spreadsheet, immediately prior to the summary lines
If this column has a blank cell Copy data from this cell
Column C – Contract-No Column I – Product-Name
Column E – Sales-No Column F – Owner-No
Column H – Client Name Column G – Owner-Name
Column J – Movt-Eft-Date Column O – Settlemnt-Date
Delete summary rows at the end of the document - “If you have any enquiries….” Up to and
including “END OF FILE” row
ID Proyek: #9828769
Tentang proyek
Diberikan kepada:
Hello , I would like to work on your project. I have great experience using excel, and macros / vba. My strongest part is data manipulation in excel through vba code. I intend to create macro launched from 1 command bu Lebih banyak
31 freelancer rata-rata menawar $74 untuk pekerjaan ini
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Lebih banyak
Hi, I am an Excel macro expert and would be happy to take on your project. Let me know and kindly provide sample file with data. Regards, Arul
EXCEL/VBA expert at you service. Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
Hi Sir, I can write the required macro within a couple of hours. Please discuss so we may begin. Thank you, Usman.
Hi, I would love to work on this project. I am a qualified chartered accountant (CPA equivalent). I have 8 years of rich experience in Microsoft Excel including working with financial modeling, macros and dashboards Lebih banyak
Can you please share the spreadsheet? I can create a macro to perform the described actions. .
I can complete the job within 2 hours . Please check my past reviews. I have 10+ years of experience in Excel & VBA. I assure you 100% accurate solution. Please ping back the file. Thank You Regards Rishi
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 60+ are complex VB/VBA projects, hence i can definitely deliv Lebih banyak
Hi, We are experts in Excel based operations and we can do this job really quickly. Kindly let us know if you want to discuss. Regards, Pal
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Lebih banyak
Hello, I am interesting to your project and placed bid for your consideration. With my experience in excel formulas, template's and macro I am confident that I will able to complete your project as per timeline and req Lebih banyak
Hi, This is an intersting project. I will complete it today. Please contact me for further details of your project. Thanks!
Local Australian with extensive excel/vba experience in an reporting and analytics. Ive worked as an operations analyst at some of the biggest ecommerce companies in aus/globally (eBay, Groupon) creating automated solu Lebih banyak
I have 4 yrs experience in excel macro. I can create an add-ins for excel. I did few automation for my organization research team. currently I am working in on automation process. I can do this at the earliest time.
Ready to start RIGHT now dear and give you 100% need and clear task all time and check and will dubble check your task.
Dear Sir, I am an Electrical Engineer with 2 years Experience using VBA, Excel. I have also experience with data scrapping, please send me the Excel file. I hope that my work satisfies your requirements, and I also Lebih banyak
Dear Sir/Madam, The project can be completed well in time with 100% accuracy.I had developed a lot of macros to simplify my routine work. Regards Reji Joseph
Hi, I may be new but I am old in experience . I assure you that I will deliver the work with maximum satisfaction. I have 7 years of working experience on excel. Thanks Amit