Help! for using an appropriate function/Macro in Excel
Dear All,
I need help in creating an excel sheet to form a format of form in sheet 1 using the data in sheet 2. I am not able to use the Vlookup or any other function in it. I want every data to be filled automatically when I fill the name in sheet one. Basically I want to use the excel functions in such a way so that the data from sheet 2 is taken to sheet one as soon as I change the name in sheet 1. Bottleneck here is that there is multiple entries of data in sheet 2 for same "Name of the deductee". Eg for "A" , there are four entries and I want all the four entries to be fille in Sheet A when I fill the name "A" on first sheet.
Please check the attached excel.
Can anyone help me in solving this issue? Kindly help as soon as possible.it is very urgent...
Waiting for a solution.....
regards
Pawan
|