Suljettu

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

Taidot: Excel, Visual Basic, PHP, tietojärjestelmäarkkitehtuuri, Javascript

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Waldorf, United States

Projektin tunnus: #20939532

35 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön

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 Lisää

$25 USD / tunti
(728 arvostelua)
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 Lisää

$15 USD / tunti
(239 arvostelua)
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 Lisää

$20 USD / tunti
(92 arvostelua)
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 Lisää

$18 USD / tunti
(361 arvostelua)
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 Lisää

$25 USD / tunti
(209 arvostelua)
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 / tunti
(269 arvostelua)
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 Lisää

$20 USD / tunti
(75 arvostelua)
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 Lisää

$22 USD / tunti
(130 arvostelua)
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 Lisää

$20 USD / tunti
(150 arvostelua)
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 Lisää

$20 USD / tunti
(322 arvostelua)
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 Lisää

$25 USD / tunti
(22 arvostelua)
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 / tunti
(247 arvostelua)
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] Lisää

$20 USD / tunti
(117 arvostelua)
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 Lisää

$20 USD / tunti
(122 arvostelua)
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 / tunti
(16 arvostelua)
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 Lisää

$20 USD / tunti
(77 arvostelua)
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 Lisää

$22 USD / tunti
(7 arvostelua)
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 Lisää

$15 USD / tunti
(34 arvostelua)
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 Lisää

$21 USD / tunti
(29 arvostelua)
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 Lisää

$30 USD / tunti
(32 arvostelua)
5.1