Lengkap

Excel Macro to manipulate table

Requirements for the creation of two Macros

Input

- Excel file with variant number of columns, can be 100+ columns

- One column is "Percent" (location of column is not known)

- The excel holds a list of invoices line items, there might be more than a single row per invoice

- Each invoice has an ID

Macro Requirements

- Two Macros are required

- The Macro will create a new table instead of the existing one, on the same sheet

- For each Vat Percent a column will be created, e.g. if there there are distinct values of 7,19,22 in the Percent column then three new columns will be added "VAT 7%", "VAT 19%", "VAT 22%"

- The value of "Total Vat Claim Amount" should be summed (SUM function)

- Two Macros are required:

-- Macro A - in the first variant there is a single row per invoice, the sums of VAT are accumulated per value in the correct column. e.g. If for ID #223 there are 3 lines, one with Total Vat Claim Amount of 100 and Percent 20, second will Amount 80 and Percent 10 and third with Amount 60 and Percent 20 the Macro will create a new table with two new columns (VAT 10% and VAT 20%) and there will be a single line for the invoice ID where in VAT 20% the value will be 160 (100+60) and in column VAT 10% the value will be 80.

-- MACRO B - in Macro B the same columns will be created by there will be a separate line for each invoice per the VAT Percent. e.g. in the case above there will be one row where the value of VAT 10% is set to 80 and VAT 20% is empty and one line where VAT 20% is set to 160 and VAT 10% is empty.

Macro should be documented in a way that will enable modifications

Delivery time in 3 days.

In order to verify the requirements are clear. Before starting development it is expected developer will create two options from the attached Excel that will demonstrate how new Macro will work.

Kemahiran: Pemprosesan Data, Excel, Excel Macros, Visual Basic

Lihat lagi: excel macro compare table, solidworks visual basic macro design table, excel macros simplify processes work, excel vba resize table, excel vba reference table column, excel vba create table from range, excel vba reference column by header, excel vba reference table cell, databodyrange vba, excel vba add data to table, excel vba loop through table rows, excel custom pivot table, excel macros manipulate internet, excel mysql create table software, company requiring excel offline data entry work, macro extract table pdf excel, excel macro extract table data website, excel macro display table data, macro word table excel, excel macro interact table calculation

Tentang Majikan:
( 0 ulasan ) Tel Aviv, Israel

ID Projek: #19328030

Dianugerahkan kepada:

Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T Lagi

$55 USD dalam 0 hari
(32 Ulasan)
4.1

19 pekerja bebas membida secara purata $140 untuk pekerjaan ini

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. Lagi

$250 USD dalam 4 hari
(327 Ulasan)
7.9
dgled

Shalom, I can manipulate and populate additional functions into specific columns in your databse. Also, Excel can validate the data and prepares reports (auto pivot tables) and documents based on the needed parameters Lagi

$250 USD dalam 3 hari
(78 Ulasan)
7.0
polarjin2017

This is Excel /VBA result which I 've done [login to view URL] This is what i have done in Excel/VBA/MACRO. Just Crreating forms, query, Macro, custom formula, etc... I;ve done so many jobs in excel like l Lagi

$150 USD dalam 3 hari
(80 Ulasan)
6.6
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$150 USD dalam 2 hari
(308 Ulasan)
6.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

$155 USD dalam 3 hari
(102 Ulasan)
6.2
dvcontact

Hi, Would you like to see a quick demo of your project on building two Excel Macros that will perform some tasks on an invoice file completed before you award the project? You can consider it professionally done in le Lagi

$150 USD dalam 3 hari
(44 Ulasan)
6.0
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] Lagi

$100 USD dalam 2 hari
(90 Ulasan)
5.5
lightingdavid

Hello. I have good skills in "Data Processing, Excel, Excel Macros, Visual Basic". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully an Lagi

$140 USD dalam sehari
(64 Ulasan)
5.6
nvchien94

Hello there, I am an Excel coder with over 200+ macros and VBA scripts created. I can create a munipulate function for you. I think it will cost 3 -4 hours if your requirement is the same with project description. Lagi

$80 USD dalam sehari
(64 Ulasan)
4.9
Stephenrajs

Hi there, I have a Team. I can do it. I have done many related projects like this. If you are provide this work, it will help my career also. Give me a chance to do this. Waiting for your precious reply. Thank Lagi

$100 USD dalam 3 hari
(84 Ulasan)
4.6
supergana

Hi - I prepared the file explaining my understanding but unable to attach. If you can send me a message i can share it right away. To the best of my knowledge, Macro1 can be achieved without VBA. Macro2 i need to se Lagi

$160 USD dalam 3 hari
(24 Ulasan)
4.7
atulamol

Hello Sir, IN my team i have 8 yr+ Experience Excel, VBA, Micro Developer. he can develop a Micro for your task. i want your requirement in details. For more discussion feel free to chat .

$200 USD dalam 3 hari
(6 Ulasan)
3.0
bluesea1990

I have many experiences in ACCESS, Excel VBA developing and data mining. I'm software engineer and algorithm expert. Your task is suitable with me. I'm also perfected in C, C++, C#, SQL, PHP .... Regard your good .

$155 USD dalam 3 hari
(2 Ulasan)
2.5
MDHedayet

Hello boss, I am hedayet ali.i looking your project i do mind that i am a beast candidit for your [login to view URL] I AM SEO SPECIALIST Experienced: MS-word Expert MS-Excel Expert MS-powerpoint Expert Copy-Past Ex Lagi

$35 USD dalam 3 hari
(0 Ulasan)
0.0
naishodayo

Hi,dear. I am a senior software developer. I am good at Excel Macro. I have just checked your project description, I am able to complete this project. I am looking forward to your proposal. Thanks.

$250 USD dalam 3 hari
(0 Ulasan)
0.0
usamabutt616

I am [login to view URL] i want to work online for the sake to get new experience of the business market. Moreover i am also professionally trained in the working with the Microsoft excel and similar work panels. I have als Lagi

$122 USD dalam 3 hari
(0 Ulasan)
0.0
seoexpertsr

Hi, Greetings of the Day! Thanks for sharing your requirement and I will be more happy to assist you in this. Given a chance for an interview, I will be happy to discuss in detail about the requirement and assist y Lagi

$45 USD dalam 3 hari
(0 Ulasan)
0.0
bluebear1888

**************Hi! Nice to meet you!! We have over 10 years IT experience as a back-end, front-end. We've been successfully completing many projects from simple project to complex one. Our key skills are: C - jav Lagi

$111 USD dalam 3 hari
(0 Ulasan)
0.0