Kapalı

Build an Excel scrip

We would like to build a scrip that imports a list of fields from an Excel spreadsheet , fills out the Excel spreadsheet, apply the formulas inside the Excel , create tabs for each year with the same formulas and creates a summary tab.

Here are the directions:

1. The end user will fill out the “import List” tab

2. The scrip will analyze the data in the "import tab", create a tab for each year (in the example, there are two years: QBAI2010 and QBAI 2011) based on the date of the item.

3. The scrip will pick up the details from the import list and place in the relevant tab based on the year. For example, all of the asset from 2010 will be placed into the QBAI 2010 tab and all of the asset from 2011 will be placed into the QBAI2011 tab

4. Inside the Excel there are all of the formulas that we would like to achieve for each year. The tab QBAI2010 is already fill out with the formals. Please do the same formals for the rest of the tabs: QBAI 2011, QBAI2013-QBAI2018. In other words, QBAI 2010 should be mimic for each year data.

5. The scrip will create a summary based on the Summary tab.

I have attached the Excel as an example

Beceriler: Excel, Visual Basic, PHP, Yazılım Mimarisi, Javascript

Daha fazlasını gör: excel countif data hourly date wise, excel export data mysql date, build excel pread sheets, excel macros 101, excel macros examples, use of macros in excel, how to create a macro in excel 2016, how to create a macro in excel 2013, macro in excel meaning, how to create a macro in excel 2010, excel macros for dummies, build excel pivot table, excel changes csv number date, build excel vba functions, excel macros import csv date time, aspnet build excel pivot table, build excel pivot table text file, microsoft excel spreadsheet templates birth date pools, build excel reports php mysql, build excel calculator php

İşveren Hakkında:
( 0 değerlendirme ) Waldorf, United States

Proje NO: #20939532

Bu iş için 35 freelancer ortalamada $19/saat teklif veriyor

jaylancer43

Hello, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (goo.g Daha Fazla

$25 USD / saat
(728 Değerlendirme)
8.5
Webxpert4u

Roy! I am ready to write code in excel file to make a script to imports a list of fields from an Excel and to fills out the Excel and to apply the formulas inside the Excel , create tabs for each year with the same fo Daha Fazla

$15 USD / saat
(239 Değerlendirme)
8.0
idragon712

Hello. How are you? I have rich experience with Excel SpreadSheet. Please kindly check following my previous works related excel spreadsheet. https://www.freelancer.com.au/projects/php/Project-for-Yanying-20420141/revi Daha Fazla

$20 USD / saat
(92 Değerlendirme)
7.9
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Daha Fazla

$18 USD / saat
(361 Değerlendirme)
8.0
PigtailXL

Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using dif Daha Fazla

$25 USD / saat
(209 Değerlendirme)
7.5
zExcel

I'd be happy to help you on this interesting project, and I can also give you a fixed price offer if you prefer to do it that way. Let me know. . .

$22 USD / saat
(269 Değerlendirme)
7.7
phpdeveloper100

Expert in doing these project Please open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator - Magento - Laravel - Wordpress - Zen-cart - X-Cart - Website Daha Fazla

$20 USD / saat
(75 Değerlendirme)
7.3
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed Daha Fazla

$22 USD / saat
(130 Değerlendirme)
7.4
Mickelson

Hi Nice to meet you. I have built so many python scripts for automation works. I checked your attachment. Also checked QBAI tab carefully. No problem to populate with your summary. Let me know more details. Regards Lia Daha Fazla

$20 USD / saat
(150 Değerlendirme)
7.1
TonmoyRoy111

Dear client I can write the macro code for you which will solve the purpose. I understand the requirements completely and I ensure the job will be done accurately. I estimate time of completion to be 7-8 working hours Daha Fazla

$20 USD / saat
(322 Değerlendirme)
6.8
lavizsolutions

Hi there, Greetings, I have checked the excel file all 5 tabs, need to understand the formulas, how to use Import list and rates tab in main tabs. Please check once.. 1. Case Management system. http://lavizsolut Daha Fazla

$25 USD / saat
(22 Değerlendirme)
6.5
expertatwork

Hi there, thanks for the heads up, yes, I can import and update excel fields accordingly. Please reply, we can get started. Thank you.

$15 USD / saat
(247 Değerlendirme)
6.3
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Daha Fazla

$20 USD / saat
(117 Değerlendirme)
5.9
beltran0404

Hello, I am Luis and I will be glad to assist you with your project. I know about Excel and Visual Basic and I can do this project fot you. Please contact me by chat then we could discuss further detials! Luis Romer Daha Fazla

$20 USD / saat
(122 Değerlendirme)
5.5
trustworthyDev

Hi, I have experience in excel working, formulas, macros, pivot, ... please contact me so that we can have a discussion in detail

$20 USD / saat
(16 Değerlendirme)
5.9
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radi Daha Fazla

$20 USD / saat
(77 Değerlendirme)
5.6
SecureForYou

Hi,sir. Thanks for taking your valuable time for reviewing my proposal.I'm a senior developer with over 10 years of experience. I think I can be a candidate for your project. If you can give me your project, I'll do my Daha Fazla

$22 USD / saat
(7 Değerlendirme)
5.3
TopDesigner315

Hi, nice to meet you. I am database expert in IT company. I am top in database field in my company. I have been working database expert for 8 years. My skill is Python, Mysql, Postgresql, Excel, deep mathematician know Daha Fazla

$15 USD / saat
(34 Değerlendirme)
5.2
Dominantsoftech

Hello there, You can have these services for your project. -Great Communications -Creative designs -Clean Code by 7+ year experienced expert developer -Dedicated Project Manager -Dedicated Server Manager -Project Analy Daha Fazla

$21 USD / saat
(29 Değerlendirme)
5.4
bhupendrayadav

I can develop a script to analyse the data in import tab and fill the yearly tabs with their respective data along with replicating the formulas from QBAI2010 tab to all year's tab, and also prepare a summary on summa Daha Fazla

$30 USD / saat
(32 Değerlendirme)
5.1