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

Attached Files

Excel function.xls (39.5 KB, 4 views)

I have added macros to the workbook that do what you requested. If you change the name of the sheets or the location of the data on the sheets, the macros won't work.
One macro in in Sheet1 (Worksheet_Change) and the other is in Module1 (GetData)

Attached Files

Excel function.xls (59.5 KB, 1 views)