nischal448
Board Regular
- Joined
- Mar 5, 2008
- Messages
- 112
Hi,
I have two excel sheets, sheet A is the master data sheetwhich has all my resource data,like, employee number,first name, last namedesignation etc., and in the other sheet i will have to input data manually. Here, the common data in the both sheets is the Employee number.
However, once i enter the employee number in my sheet B, i need the fields like designation etc to get updated automatically from the sheet A. vlookup is not working, because I periodically enter the employee number in the sheet B and not as a bulk. My final question is , if I enter the employee number in the sheet B , can it pick all the details from the sheet A and fill my columns??
Kindly help
Regards,
Nik
I have two excel sheets, sheet A is the master data sheetwhich has all my resource data,like, employee number,first name, last namedesignation etc., and in the other sheet i will have to input data manually. Here, the common data in the both sheets is the Employee number.
However, once i enter the employee number in my sheet B, i need the fields like designation etc to get updated automatically from the sheet A. vlookup is not working, because I periodically enter the employee number in the sheet B and not as a bulk. My final question is , if I enter the employee number in the sheet B , can it pick all the details from the sheet A and fill my columns??
Kindly help
Regards,
Nik