Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search open sheets in workbook and insert into open sheet
SHEET 1: DAY SHIFT SHEET 2: SWING SHIFT SHEET 3: NIGHT SHIFT SHEET 4: EMPLOYEE DATA I Have A List Of Employees On Sheet 4 As They Check Into There Shift The Counter Worker Takes There Card Number (colum D) And Types It Into The Search Box. Enter. It Will Search The Open Sheet 4 For The Card Number And Grab The Entire Row For That Number. I.e Search For 2542296 Finds It In Sheet 4 And Grabs Last Name First Name Work Card Number Work Card Exp Dob And Status And Inserts It Into The Open Sheet That It Was Searched From I.e Day ****. If I Search From Day Shift Sheet I Want To Insert The Data For The Day Shift If I Search Within The Night Shift It Will Put The Data In The Night Shift Sheet. (from Sheet 4 Always Sheet 4) ----------------------------------------------------------------------------------------------------------------------------------- *A B C D E * LAST NAME FIRST NAME STAGE NAME WORK CARD # WORK CARD EXP. I HOPE THIS MAKES SENSE... PLEASE POST IF YOU HAVE THE ANWSER IM LOOKING FOR AND THANK YOU IN ADVANCE. +-------------------------------------------------------------------+ |Filename: SPECS.doc | |Download: http://www.excelforum.com/attachment.php?postid=4422 | +-------------------------------------------------------------------+ -- punx77 ------------------------------------------------------------------------ punx77's Profile: http://www.excelforum.com/member.php...o&userid=32191 View this thread: http://www.excelforum.com/showthread...hreadid=519393 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert the same header in every sheet in a excel workbook | Excel Discussion (Misc queries) | |||
Copying information and calculations from one sheet to another she | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |