Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2009, 03:16 AM
pawan2paw pawan2paw is offline
Novice
Help! for using an appropriate function/Macro in Excel
 
Join Date: Apr 2009
Posts: 1
pawan2paw is on a distinguished road
Default 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
Attached Files
File Type: xls Excel function.xls (39.5 KB, 6 views)
Reply With Quote
  #2  
Old 06-04-2009, 12:28 PM
mwoolf mwoolf is offline Help! for using an appropriate function/Macro in Excel Windows XP Help! for using an appropriate function/Macro in Excel Office 2007
Novice
 
Join Date: Jun 2009
Posts: 2
mwoolf is on a distinguished road
Default 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)
Attached Files
File Type: xls Excel function.xls (59.5 KB, 2 views)
Reply With Quote
Reply

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
Help! for using an appropriate function/Macro in Excel 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft