View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sinner Sinner is offline
external usenet poster
 
Posts: 142
Default Getting values from desired sheet for printing.

I have a workbook containing 32 sheets, one (Printsheet) for printout
with a format & rest of 31 (1,2,3,4,5....31) for each day of a month
in another format.

In the print sheet, I would like to get values in cells from the sheet
that I select.
If I write 4 in print sheet, then I should get all the values as
mentioned in sheet 4 ans so on.

I also want that the sheet number that I input should be in date
format like if I input 1/9, then it shows September 01, 2007 & gets
values from sheet 1 and so on.

I have been guessin many formulas but.... : /

would appreciate a helpin hand.