Linking Worksheets

[Joeman187]

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.

 

[Hubert]

If all the sheets are well organized, I think vlookup is a good option.

 

[Khalid NGO]

Hi Joe,
See if it helps...

 

[Joeman187]

Yes, I think that what I was looking for. Thank Khalid and Hubert for your advise.