Formula for automatically entering information from a master sheet
I'm really drawing a blank on this one!!
In my workbook I'm creating a worksheet for each employee. I would like to
input all information on a master sheet and have it automatically enter to
the correct employee worksheet.
MASTER has the following information: A1=Employee #, B1=Employee name,
A2=000, B2=Jane Doe.
TEMPLATE for Employee worksheet: B3=Employee #, C3=formula that will pull
from MASTER, B4=Employee name, C4=formula that will pull from MASTER
|