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.
i have 2+ year experience in MS-Office 100% work satisfaction Guarantee ready to start working soon as assign
3 freelancers are bidding on average $32 for this job
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
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