Terminé

Using VBA to minimize admin work and improve process efficiency.

We are a landlord looking to automate and improve our administrative process of notifying tenants who do not pay their rent.

Currently, our account department's system will produces an excel sheet called the statement of accounts (screenshot attached). It is then printed out and handed to an employee in the legal department which has to manually key in the details from the statement of accounts to create the letter of demand which is sent to tenants. This process is time consuming and can be automated through VBA. Unfortunately, a simple mail merge will not work as the system generates new excel sheets for each tenant

Essentially, we need to create a mail merge, but with dynamically adjusting fields within the excel sheet, as different tenants owe various amounts.

Screenshots of both the Letter of Demand (highlighted fields indicate which need to be manually updated) and Statement of accounts have been included.

Compétences : Excel, Visual Basic

en voir plus : click link using vba, copy form using vba, saturday admin work, vba in excel, vba examples, vba code, vba tutorial, how to use vba in excel, learn vba, is vba worth learning, what is vba, login website using vba, data excel workbook master workbook using vba, using password oscommerce admin, print access report pdf file using vba, mhtml part body email using vba, vba excel spreadsheet work, install add using vba, need admin work done, using vba log website

Concernant l'employeur :
( 0 commentaires ) Singapore, Singapore

Nº du projet : #17765487

Décerné à:

archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilizat Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% SGD en 2 jours
(74 Commentaires)
5.7

35 freelance font une offre moyenne de $164 pour ce travail

schoudhary1553

Hello! This is vibrant webtech and I was glad to see that you're looking for help for project Using VBA to minimize admin work and improve process efficiency.. I've delivered more than 400 + projects in the last 5 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 4 jours
(275 Commentaires)
7.6
paris2785

Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to automate the process of creating the Letter of Demand based on data entered in your Excel Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(159 Commentaires)
6.8
mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on excel/vba/macro tasks of various complexities, I can help you in getting your task done quickly and efficiently. I will help you out wi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(88 Commentaires)
5.7
usmanhassan123

PhD in computer science having seven years of experience in Excel development and visual basics.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(39 Commentaires)
5.8
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Have worked in similar projects. Willing to take up your project. Th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(63 Commentaires)
5.6
liangjongai

Hello. I'm interested in your project as very well. I'm excel developer and can work as full time. And I have good experience in vba develop. I am mastering in vba and excel. I can show you my work if you want. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(8 Commentaires)
5.1
supper5guy

Hello thee, as an expert in excel and VBA, i can help you to develop a script that will get the required data and auto-populate your sheet and word document. Please contact me and let us talk more about your project. T Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(68 Commentaires)
5.3
aubrey03

I am a VBA expert and I have done a similar project before so I am confident that I am the best freelancer for this project. You may check some of my projects here: [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(51 Commentaires)
5.1
vmadhavan15

am not a random bidder.. Please ping me if you ar einterested with my proposal and share more detail.. thank you..

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(23 Commentaires)
4.8
vijayvizzu7

Hi I read your description and saw your attachment. I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. I am sure i can handle your request

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(6 Commentaires)
3.8
paulodayto08

Hi Good Day! May I know if you are using Office outlook? I can do that using Excel and outlook integration. I am a PMO Analyst and my primary task is generating a Financial reports. I am exposed on different Excel F Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 2 jours
(11 Commentaires)
3.2
krishnaagr89

Hi,I have read your requirements of Using VBA to minimize admin work and improve process efficiency. and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 4 jours
(3 Commentaires)
2.9
qinchetan

This is a very simple VBA. You have an excel statement and based on it you need to create a letter(print). Please provide the the letter in WORD and statement in Excel. ------------------------------------------- I Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(3 Commentaires)
1.5
ENRICOJ

hi.i would be happy to develope the same system using ms access,wich is also part of ms office. ms access is a more realistic database management infrastructure. please contact me for further assistance kind regards Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 10 jours
(2 Commentaires)
1.2
reedsystems

Hello there, how are you today? I read your project description and I understand that you need a vba expert to automate the process of statement and letter of demand generation. I can provide you with exactly wha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 7 jours
(2 Commentaires)
1.6
mail2azharsayed

Working with a mnc compnay.. having 12 years of experience in Excel & VBA... If i will get this project will help you for any further changes also.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 6 jours
(0 Commentaires)
0.0
studeto

Hello, I started the transfer project and see here 2 interim results in pictures: [login to view URL] [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(0 Commentaires)
0.0
ariniazi2005

Hi I have done diploma in MS office and VBA and this is my first project so I am doing it with dedication for my profile best rating

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 4 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 4 jours
(0 Commentaires)
0.0