View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
coconut78 coconut78 is offline
external usenet poster
 
Posts: 2
Default Match, VLookup... who knows?

OK, from Access, I have a table that is exported into an Excel Workbook.
This workbook, an attendance log, is formatted as follows:

Child1 TimeIn TimeOut Date
Child2 TimeIn TimeOut Date
Child3 TimeIn TimeOut Date
Child1 " " "
Child2 " " "
Child3 " " "

I have linked a completely different Excel Workbook to this workbook, and
want to change the format to:

Child1 Child2 Child 3
Date TimeIn TimeOut TimeIn TimeOut TimeIn TimeOut
Date TimeIn TimeOut TimeIn TimeOut TimeIn TimeOut

How do I search the export from access to match BOTH the Date and the Child
to find the TimeIn and TimeOut?