Sedang Disiapkan

226311 VB script in Excel

Need the script to manipulate data in Microsoft Excel.

The script to do the following.

Input

two tables

table 1 consists of columns

key1 data1 data2 data3 data4 .......

table 2 consists of columns

key2 dataA dataB dataC dataD .......

Output

1 table consisting of columns

key3(comprising of unique values of key1 and key 2)

data1+dataA ......

data2+dataB ......

....

....

sample:

key3 is calculate thus

key1 = 1, 4, 5, 7

key2 = 2, 4, 6, 7

key3 will be = 1, 2, 4, 5, 6, 7

The two tables will always contain the same number of columns.

script must allow me to define the two tables using color codes

script must allow me to define where to output to.

script must be able to handle a variable number of columns and rows

I want the script not just the output data.

Kemahiran: Semua Boleh, Visual Basic

Lihat lebih lanjut: data3, vb excel, excel 7, datad, output script, sample visual basic excel, excel unique, excel manipulate data, microsoft excel script, excel data table, excel data tables, codes excel, excel rows, color script, excel contain, data4, key visual, table excel, script data input, rows excel, visual basic script excel, visual script, script visual, tables excel, color sample excel

Tentang Majikan:
( 7 ulasan ) Sydney, Australia

ID Projek: #1972549

Dianugerahkan kepada:

johnsinit

Dear bellpac! Bidding as discussed in PMB. John.

$28 USD dalam sehari
(8 Ulasan)
3.7