View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jackie[_4_] Jackie[_4_] is offline
external usenet poster
 
Posts: 3
Default Printing A Chart

I have a date in cell JI (dd/mmm/yy) I would like to print the corresponding
months chart, which is on a separate sheet. The tabs are named *** Sept**
and *****Oct*** etc, * = letters/numbers, person who set the charts up
didn't follow the same naming method for each chart. Is it possible to
search the tabs for the three letter month abbreviation and print that
chart.

Date = 28/Sep/04 print Sep Sheet
Date = 03/Oct/04 print Oct sheet

Thanks, Jackie