Devam Ediyor

VBA Macro in Excel

See file attached.

In the first sheet “scenario” I have a set of data divided in 3 columns each of them can re-direct to a matrix of numbers in sheet “data”. The macro should retrieve the data corresponding in Sheet “data” accordingly to the value set in “Scenario “ sheet. For example, in Sheet “Scenario” Col 1 = Class2 Col2 = Sea3 Col 3 = 21, the macro should select in the sheet “data” the cell intersecting Class2/Sea3/ starting at 21 which in the sheet correspond to -3010. Starting from this cell selecting the entire row and copying all the selected values in the sheet “Output” the value selected in the specific row/column intersection having same format.

It shall be dynamic that i can change different set of information in scenario, which will correspond different set of values in the matrix. The file attached is just an example. As long as it works having different data values is fine.

The code can be delivered by returning the example file, payment at delivery.

Beceriler: Excel, VB.NET, Visual Basic

Daha fazlasını görün: intersection data, intersection and, excel vba long, excel scenario, vba code excel, vba excel, macro vba, macro excel, excel vba macro, excel row column, excel macro row, vba matrix, sheet excel visual basic, excel 2014 macro, excel vba macro file, excel format cell, excel cell format, macro vba cell, excel change data format, cell excel vba, vba sheet, macro cell value, excel vba cell, attached vba, select matrix

İşveren Hakkında:
( 4 değerlendirme ) Dublin, Ireland

Proje NO: #6506720

Seçilen:

patelhemang12

i have 2+ year experience in MS-Office 100% work satisfaction Guarantee ready to start working soon as assign

3 gün içinde 25$ USD
(3 Değerlendirme)
1.2

3 freelancer bu iş için ortalamada 32$ teklif veriyor

nazmulcb

Dear Sir, quality and expert researcher here to search a targeted group of people, images, email addresses, database or anything that you are needed you may hire me in full confidence

in 5 gün içinde50$ USD
(26 Değerlendirme)
4.8
kyru

I good in Excel VBA having real time experience also, Im working in excel for past 5 years i have created lot of excel macros to generate report in excel with full formating

in 3 gün içinde20$ USD
(0 Değerlendirme)
0.0