Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to fetch rows of data across sheets dynamically
Hi all I maintain some info that is spread across 4 sheets in a single excel book . In the first three I maintain employee info( empid,empname...and other details reg the employee) of 3 different dept.Empid is the first column (common)of all the sheets. Now, my requirement is, when ever I enter an empid in the first column of the fourth sheet, and, if it already exists in any of the 3 sheets,it should fetch the details of that employee into the fourth sheet(the complete row). If the empid is NOT in any of the 3 sheets, then , it should allow me to add details of this employee in the fourth sheet. Kindly let me know in detail as to how to go about it. Thank You in advance. Regards Eddy -- knowledgehunter ------------------------------------------------------------------------ knowledgehunter's Profile: http://www.excelforum.com/member.php...o&userid=29333 View this thread: http://www.excelforum.com/showthread...hreadid=490472 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I fetch multiple rows back using VLOOKUP? | Excel Worksheet Functions | |||
Use of Indirect function to fetch data from another Excel file | Excel Worksheet Functions | |||
Fetching rows across sheets dynamically | Excel Programming | |||
Fetching row data across sheets dynamically | Excel Programming | |||
Dynamically Creating Sheets | Excel Programming |