Getting data from a closed workbook to a master record
 

Hi, i got a workbook named Login for user to add in new equipment, those
details will then be inside a workbook named New equipment. There are
several worksheets in the workbook(New equipment) the details are
record in the various worksheets according to their type. The details
include New ID, Description, Type, Date, and user name. Then if i have
another workbook named Master record and i want the master record
workbook to extract the data from new equipment workbook but only
details like new ID date and user name and the master record must also
be able to update its record when the user adds in or remove a
equipment. How do i do that ?


--
Garcia
------------------------------------------------------------------------
Garcia's Profile: http://www.excelforum.com/member.php...o&userid=32736
View this thread: http://www.excelforum.com/showthread...hreadid=526607