В работе

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

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.

Навыки: Excel

Показать больше: the design files, qr code icon, people icon design, job proposal example, icon payments, example of the proposal, example of job proposal, example job proposal, design icon next, automated logic, add icon, excel spreadsheet formulas macros, vba add spreadsheet form, add references excel macros vba, print version design spreadsheet, vba add ins instal, check file exists vba add number, vba add reference add ins, vba add numbers, macros vba con solidworks, excel vba add installation

О работодателе:
( 11 отзыв(-а, -ов) ) Staffordshire, Poland

ID проекта: #8551569

Поручено:

someka

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 Больше

$184 USD за 3 дней(-я)
(34 отзывов(-а))
4.6

31 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $182

zExcel

A proposal has not yet been provided

$205 USD за 2 дней(-я)
(203 отзывов(-а))
7.2
cugamelover

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 project Больше

$180 USD за 3 дней(-я)
(47 отзывов(-а))
5.9
prameswara

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 за 3 дней(-я)
(137 отзывов(-а))
5.9
vikas0903

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 Больше

$188 USD за 5 дней(-я)
(36 отзывов(-а))
5.6
dviruki

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 Больше

$150 USD за 3 дней(-я)
(63 отзывов(-а))
5.2
kannasanthosh

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 pro Больше

$188 USD за 3 дней(-я)
(14 отзывов(-а))
5.3
gokulanand

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 Больше

$200 USD за 3 дней(-я)
(62 отзывов(-а))
5.3
tomislav1975

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 за 3 дней(-я)
(32 отзывов(-а))
5.1
kevivu

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-engineeri Больше

$211 USD за 3 дней(-я)
(33 отзывов(-а))
4.9
Khurramz

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 Khur Больше

$200 USD за 7 дней(-я)
(59 отзывов(-а))
4.7
d2imatrix

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 за 3 дней(-я)
(20 отзывов(-а))
4.8
AlexandrK1

A proposal has not yet been provided

$250 USD за 5 дней(-я)
(13 отзывов(-а))
4.5
redouaneaberdin

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 за 3 дней(-я)
(38 отзывов(-а))
4.0
akshay175

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 p Больше

$150 USD за 7 дней(-я)
(12 отзывов(-а))
4.1
Baxter2008

A proposal has not yet been provided

$277 USD за 10 дней(-я)
(19 отзывов(-а))
3.9
slenders13

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 за 3 дней(-я)
(8 отзывов(-а))
3.5
gsanggara

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 requir Больше

$160 USD за 3 дней(-я)
(3 отзывов(-а))
2.1
andreapellicci

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. Больше

$150 USD за 3 дней(-я)
(9 отзывов(-а))
2.2
SHhadun

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 barco Больше

$180 USD за 7 дней(-я)
(6 отзывов(-а))
1.9
aisvaryayemi

I am Excel professional who worked in KPMG. I have experience developing Excel and macro based models such as Cash flow forecasting model, trading monitoring system, compliance rulebook, risk based pricing model, liqui Больше

$155 USD за 1 день
(1 отзыв)
1.5