An interesting Task

Closed
Revo - Aug 30, 2009 at 06:02 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 3, 2009 at 02:52 AM
Hello,
I have a main worksheet, that is from suppose operation department which contains the daily record of all employees who are present same like attendance register and all employees are at one work book. And in account department I have one worksheet against one employee to calculate its monthly attendance and so they can process it salary as per his attendance. Now I want a way that those individual sheets will be updated from the basis of man worksheet data. Is it possible to get results in other sheets while data is in another sheet

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Sep 3, 2009 at 02:52 AM
use VLOOKUP(lookup_value,table_array,col_index_num,false)
0