My question is that I have a Excel workbook that I want to get information from a cell in worksheet 1 for a specific date to go to a cell in workbook 2 for that specific date as well. This is being used as a yearly attendance workbook. In worksheet 1 it will track it will track their hours worked, sick time, vacation time, overtime, holidays. In worksheet 2 it will track their yearly record of vacation time, sick time, & holidays time off, so at the end of the year or someone asks how much time they have left we can just open this workbook and get that information for them. Thanks
Sorry, failed to see the question.
Can you describe it in a different more detailed way.
Preferably with some examples of how your sheets looks like.
You could also use a site like www.speedyshare.com to post your workbook.