J Joeman187 Member Oct 24, 2014 #1 Hi Chandoo Experts, I am working on this payroll chart and would like to know how to add a new employee and link his/her information to the other tabs. I thought I could use the offset function for this. Let me know what your thoughts are. Thanks, Joe. Attachments Payroll A.xlsx 25.8 KB · Views: 7
Hi Chandoo Experts, I am working on this payroll chart and would like to know how to add a new employee and link his/her information to the other tabs. I thought I could use the offset function for this. Let me know what your thoughts are. Thanks, Joe.
H Hubert New Member Oct 24, 2014 #2 If all the sheets are well organized, I think vlookup is a good option.
Khalid NGO Excel Ninja Oct 24, 2014 #3 Hi Joe, See if it helps... Attachments Payroll A (1).xlsx 39.3 KB · Views: 8
J Joeman187 Member Oct 24, 2014 #4 Yes, I think that what I was looking for. Thank Khalid and Hubert for your advise.