Find Jobs
Hire Freelancers

Customer Client Statements from Excel Spreadsheet

$250-750 USD

Ditutup
Dibuat sekitar 11 tahun yang lalu

$250-750 USD

Dibayar ketika dikirim
How good are you guys at Excel? We have the ability to export all client accounts to an excel sheet each quarter but from here we would need a custom Mail merge that would allow it to take that excel sheet and translate it to customer statements. If it were a simple one account per person I can do that mail merge no problem, but some clients may have 1-6 accounts. Each client has an identifying client #, but the spouse would have a separate one. I know it can be done, but it is beyond my realm Example ID First Last Account Name Account Number Amount 1 John Anthony Allianz 12345 $100,000 1 John Anthony Curian 98765 $50,000 2 Alta Anthony Allianz 22222 $200,000 3 Chris Kirk Allianz 55555 $100,000 A mail merge would have to be created to look like this ------------------------------------------------------------------------------------------------- John Anthony Allianz 12345 $100,000 Curian 98765 $50,000 Alta Anthony Allianz 22222 $200,000 Household total $350,000 ------------------------------------------------------------------------Page break Chris Kirk Allianz 55555 $100,000 Household Total $100,000 -------------------------------------------------------------
ID Proyek: 4417771

Tentang proyek

28 proposal
Proyek remot
Aktif 11 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
28 freelancer menawar dengan rata-rata $309 USD untuk pekerjaan ini
Avatar Pengguna
I can provide very easy solution to you.....Lets discuss.
$288 USD dalam 3 hari
4,9 (252 ulasan)
6,8
6,8
Avatar Pengguna
Such jobs are my daily practice. Please, see PMB for a working sample! Regards!
$250 USD dalam 1 hari
4,9 (64 ulasan)
5,7
5,7
Avatar Pengguna
I have gone through your project details. The job is clearly understood. I will create account-wise statement using mail-merge exactly as per your sample. Ready to start. Thanks!
$250 USD dalam 3 hari
4,9 (22 ulasan)
5,3
5,3
Avatar Pengguna
I am an expert in delivering custom scripts and like to deliver the project
$525 USD dalam 3 hari
5,0 (16 ulasan)
5,2
5,2
Avatar Pengguna
Let's do it. Please check private message
$250 USD dalam 2 hari
5,0 (15 ulasan)
4,9
4,9
Avatar Pengguna
Good day! I am interested in your project. Please check my private message that would follow this one for a few clarifications I need before I can confirm my project fee and estimated time of completion. Thank you.
$500 USD dalam 7 hari
5,0 (4 ulasan)
4,1
4,1
Avatar Pengguna
Definitely can be done, but it will require a macro-enabled workbook. That might be better as a separate file that read your account sheet as an input. We will have to discuss how each "household" is identified, whether by address or what. This is something we should do BEFORE going to contract. If there is no reliable link it might not be possible, and we can save the costs of starting a project that goes nowhere. Please see the attached note.
$275 USD dalam 6 hari
5,0 (15 ulasan)
3,9
3,9
Avatar Pengguna
Hi, Programmer with 8 years experience. Check your message for more details
$250 USD dalam 3 hari
5,0 (5 ulasan)
3,5
3,5
Avatar Pengguna
Please see a user friendly solution on PMB. regards
$275 USD dalam 4 hari
3,8 (2 ulasan)
4,2
4,2
Avatar Pengguna
Dear abstractls: I have experience creating several similar applications in Excel. Please see my Portfolio and Feedback history for more information. How may I make this the best bid for you? Thank you, Charlene Wright.
$275 USD dalam 3 hari
5,0 (4 ulasan)
2,8
2,8
Avatar Pengguna
Hi, Nice project that can be done easily without the mail merge. I can create specific VBA code that process these statements in the way you described. If needed, I can even add code that will save/mail these statements automatically, probably at a lower cost than proposed. Thanks, Exopad
$250 USD dalam 3 hari
5,0 (2 ulasan)
1,6
1,6
Avatar Pengguna
READY TO DO THIS!
$275 USD dalam 5 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Sounds easy, and there are several approaches that we can use, depending on your preferences. I'm a professional software developer proficient in programming languages like Java as well as scripting for Microsoft apps like Excel and Access. See private message for more details!
$350 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi Please see my PM
$350 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I can start immediatly. Thanks
$250 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I can do it very well. send me your project details.
$250 USD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I'm fast and I take pride in my work. You'll love working with me.
$250 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I'm working in finance field and i love excel.I can deliver you the project with accuracy and on time, so give me the opportunity.
$250 USD dalam 5 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I am ready to work with you. If you give this opportunity to me i will do my level best.
$522 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I do my best
$500 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED STATES
Mount Airy, United States
0,0
0
Anggota sejak Apr 10, 2013

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.