View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KUMPFfrog KUMPFfrog is offline
external usenet poster
 
Posts: 38
Default printing same tab from multiple workbooks

I currently have numerous workbooks (one for each employee) containing thier
timesheets for the current year (file name: "[NAME] TimeSheet's 2008.xls").
the tabs in these workbooks are simply named by the week ending date (every
saterday).

I would like to have a special workbook that's only perpose is to batch
print all or certain timesheets.
In this wkb, i would have a cell in which i type the week ending date that i
want to print. I am thinking it could search all files in a folder for that
tab name and print them OR furthurmore, I would also like to have a list of
employees names that I could check off, or something, if i want the timesheet
for that person printed.

would any of this be possible?
Thanks