View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victoria Victoria is offline
external usenet poster
 
Posts: 35
Default 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