Build a macro in Microsoft Excel

Selesai Dipasang Mar 2, 2016 Dibayar saat pengiriman
Selesai 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

Excel

ID Proyek: #9828769

Tentang proyek

31 proposal Proyek online Aktif Mar 3, 2016

Diberikan kepada:

nagyzoltan68

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

$30 AUD dalam 1 hari
(133 Ulasan)
6.6

31 freelancer rata-rata menawar $74 untuk pekerjaan ini

jaylancer43

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

$70 AUD dalam 0 hari
(765 Ulasan)
8.6
deepbluetech

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

$75 AUD dalam 1 hari
(173 Ulasan)
7.4
Teloquence

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.

$50 AUD dalam 0 hari
(326 Ulasan)
7.6
zebracaro

I can do it for you quickly and exactly

$70 AUD dalam 0 hari
(115 Ulasan)
7.0
maverick44000

Hi Sir, I can write the required macro within a couple of hours. Please discuss so we may begin. Thank you, Usman.

$80 AUD dalam 1 hari
(70 Ulasan)
6.7
raghav1101

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

$126 AUD dalam 2 hari
(95 Ulasan)
6.5
best4best

Can you please share the spreadsheet? I can create a macro to perform the described actions. .

$55 AUD dalam 1 hari
(145 Ulasan)
6.3
rengrish

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

$60 AUD dalam 1 hari
(146 Ulasan)
5.9
kevivu

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

$34 AUD dalam 3 hari
(72 Ulasan)
5.8
saminatinny

A proposal has not yet been provided

$35 AUD dalam 3 hari
(28 Ulasan)
4.7
d2imatrix

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

$30 AUD dalam 3 hari
(24 Ulasan)
4.8
prabakarm23

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

$55 AUD dalam 0 hari
(48 Ulasan)
4.6
gsanggara

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

$50 AUD dalam 1 hari
(27 Ulasan)
4.2
jnekam

Hi, This is an intersting project. I will complete it today. Please contact me for further details of your project. Thanks!

$66 AUD dalam 1 hari
(12 Ulasan)
3.8
TianaKay

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

$111 AUD dalam 1 hari
(3 Ulasan)
3.4
kpprakash2130

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.

$111 AUD dalam 3 hari
(1 Ulasan)
0.4
sajibdhar2

Ready to start RIGHT now dear and give you 100% need and clear task all time and check and will dubble check your task.

$155 AUD dalam 3 hari
(0 Ulasan)
0.0
akamal89

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

$50 AUD dalam 0 hari
(2 Ulasan)
0.0
Rejivenmelil

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

$45 AUD dalam 0 hari
(0 Ulasan)
0.0
agoyal2008

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

$100 AUD dalam 3 hari
(0 Ulasan)
0.0