Find Jobs
Hire Freelancers

Add macros/vba/formulas to spreadsheet and tweak the design. -- 2

$150-250 USD

Completed
Posted over 8 years ago

$150-250 USD

Paid on delivery
The document should be fully automated and all formatting and logic in place. The only thing I want to do is type the transactions and for the rest to be done itself. I have made a list of requirements. Please submit a proposal and I will send you the files if I think you are suitable for the job. A few people have tried this and they have all failed which is why I am resubmitting the job again. The level of knowledge required on Excel is high. If you have high level in VBA, macros, design and formulas, please submit a proposal. If the first one is successful then I will have others for you to do. 1. Random number generated at the top of the page and on the side of the page. This should be randomly generated when I choose it to be. Not randomly generated everytime I open the file. Numbers will follow a certain pattern. 2. Balances on both Excel tabs to be automatically shown depending on certain logic. The balance is only shown on the last transaction on that day. 3. Colours should alternative automatically between white and blue for each transaction. 4. Black lines should be shown around each transaction, these should be added automatically. Transactions can be different length and size. 5. Icons should be inserted automatically next to the transactions based on what I type. For example typing “Card Payment” will automatically insert the card icon. Typing “Direct Debit” will automatically insert the direct debit icon. 6. The list of icons shown in the middle of the page above the transactions should change depending on what icons are used in the statement. For example if the statement only has Card Payments, then this is the only icon that should be shown in the list. 7. Something on the date column to inform me when I type a date which is on a weekend. Dates on weekends are not allowed on statements. It should flag or highlight so that I can change it to another date 8. Add barcode and QR code. I will randomly generate these and send the images 9. Some design tweaks will be needed so that the design matches the original near to 100% 10. Icons should be copied over from the original documents which I will send. Icons need to be high quality. 11. Should be completed in Excel 2013 or Excel 2016. 12. Daily updates required as there will be a lot of different drafts.
Project ID: 8551569

About the project

31 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
You dont need to recruit me now. Drop me a message and i can make a free trial study for you. If you get happy, we can proceed. (as i want more references in my profile, i provide this service) I have a 5,5 years of business analyst experience in a global company and 2,5 years data scientist experience in a game company before my freelancer career. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. I am mostly online. Just drop me a message so that we can discuss further about pricing and job details. Thanks,
$184 USD in 3 days
5.0 (34 reviews)
4.6
4.6
31 freelancers are bidding on average $182 USD for this job
User Avatar
A proposal has not yet been provided
$205 USD in 2 days
4.9 (203 reviews)
7.2
7.2
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara :)
$150 USD in 3 days
5.0 (137 reviews)
5.9
5.9
User Avatar
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$180 USD in 3 days
5.0 (47 reviews)
5.9
5.9
User Avatar
Hello I am good at excel programming and macro creation. I have worked on plenty of VBA related projects here in freelancer.com. I am confident that I can get these task done well with in 48 to 72 hours. Please let me know if you are interested and share me the files. Thanks
$200 USD in 3 days
5.0 (62 reviews)
5.3
5.3
User Avatar
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in few data analytics projects involving SAS & R. Also I have worked on many projects involving Excel (Pivot Table, Macros) and VBA. I am relatively new to freelancing so I don't have many projects to showcase in this site. I believe I have enough expertise to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh Kanna
$188 USD in 3 days
5.0 (14 reviews)
5.3
5.3
User Avatar
Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on designing, implementing and analyzing ACBC (conjoint) surveys, pricing models, income statements, business analysis etc. Prior that I have completed MBA and bachelors in Engineering. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$188 USD in 5 days
4.9 (36 reviews)
5.6
5.6
User Avatar
HI, I am highly skilled in Excel and VBA, see my reviews. If you find me suitable for work pls contact me. With regards, Tomislav
$222 USD in 3 days
4.9 (32 reviews)
5.1
5.1
User Avatar
Dear Sir/Madam, thank you for the detailed project description. I have 12 years of experience in automating data processing and analysis using Excel and VBA and over 60 completed projects on Freelancer involving use of Excel and VBA. I have Excel 2013 and will be glad to help you with the project. Please contact me to discuss details. Thank you!
$150 USD in 3 days
5.0 (63 reviews)
5.2
5.2
User Avatar
Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
$211 USD in 3 days
5.0 (33 reviews)
4.9
4.9
User Avatar
Hi! I have seen your requirements. I have doubts about your requirement # 5 and 8 how it can be done. Rest is fine for me. Please if you could share the excel file to get full picture of the project. Thanks Khurram
$200 USD in 7 days
4.9 (59 reviews)
4.7
4.7
User Avatar
Hi, We are experts in excel VBA data processing. We can develop the macro based on your requirements. We have been in this area of work for last 10 Yeats. Kindly message us for further details. Regards, Pal
$167 USD in 3 days
5.0 (20 reviews)
4.8
4.8
User Avatar
A proposal has not yet been provided
$250 USD in 5 days
5.0 (13 reviews)
4.5
4.5
User Avatar
Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
$200 USD in 3 days
5.0 (38 reviews)
4.0
4.0
User Avatar
Hi, I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I have developed several dashboards in Excel previously also and can do the same for you as well. So lets discuss this project in detail and start at your earliest convenience. I can guarantee you the best possible work in least possible price.
$150 USD in 7 days
4.9 (12 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
$277 USD in 10 days
4.9 (19 reviews)
3.9
3.9
User Avatar
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
$150 USD in 3 days
5.0 (8 reviews)
3.5
3.5
User Avatar
Hi, I'm new on this site but I'm very skilled on excel, access, vba. I've already implemented some simple projects, you can see my references. I'd like to work on your project - it's challenging and this is good. §Th I'd like to better understand the outcomes you requires and this can be done only checking the file, so I'd like to receive it. if you want, I can also deliver the work before the end of the bid, so you can see what will you pay for. Then, if you like my work, you will select me as winner. If you are interested, please contact me. Best regards Andrea
$150 USD in 3 days
4.7 (9 reviews)
2.2
2.2
User Avatar
Hello, I am interesting to your project & placed bid for your consideration. I'm excel coder, with 3year+ experienced in excel coder & formulas I am very confident that i will deliver good result as per your requirement on time. Hope to hear from you soon. Thank & Regards, gsanggara
$160 USD in 3 days
5.0 (3 reviews)
2.1
2.1
User Avatar
Hi, I'm experienced CRM business analyst, and VBA coding is my daily routine. Excel file manipulation and dashboard creation is also part of my regular work. Only question I have about your task is regarding barcodes and QR codes; this images will be generated from external source, and you only want them to select and insert in Excel, OR you want to generate barcodes in Excel? Hope tho here from you soon, BR, Dusan
$180 USD in 7 days
5.0 (6 reviews)
1.9
1.9
User Avatar
Hello, I am very experienced vba developer. With experience in industry, I am confident that I can deliver your task with quality. Looking to hearing from you soon. Regards
$166 USD in 3 days
5.0 (2 reviews)
1.4
1.4

About the client

Flag of POLAND
Staffordshire, Poland
5.0
11
Payment method verified
Member since Sep 27, 2013

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.