#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Re: Help! for using an appropriate function/Macro in Excel
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) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro library | pankajkankaria | Excel | 1 | 04-12-2009 09:06 AM |
Unable to run the specified macro | jtrirogoff | Word | 0 | 02-05-2009 04:38 PM |
Macro Writing | cweachter | Excel | 0 | 08-09-2008 08:30 PM |
Need help on what function to use??? | Primeraman | Excel | 1 | 06-13-2006 10:16 AM |
Help with Combination function | sanasath | Excel | 0 | 12-13-2005 07:24 AM |