Hello,
I'm not sure exactly what formula/s I should use to get this done. I have a spreadsheet with three workbooks. The main work book with information in it,
Workbook 1 (employee info)
LAST NAME FIRST NAME PHONE NO. CITY STATE SHIFT
Dow John 555-555-5555 Portsmouth NH WD 1
Workbook 2 (Day Shift)
LAST NAME FIRST NAME
Workbook 3 (Night Shift)
LAST NAME FIRST NAME
The data from workbook 1 (employee info) should populate to workbook 2 or 3 based on SHIFT from workbook 1. if SHIFT ends in 1 populate to Workbook 2 if SHIFT ends in 2 Populate to Workbook 3.
WD 1
WD 2
WE 1
WE 2
I'm thinking something like =employee!A2,IF(employee!F2... the rest is the part I'm not sure about.
Thank you for your help.
Bookmarks