LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup for multiple values and return to one desired value nsd Excel Worksheet Functions 8 September 23rd 08 10:44 PM
Returning the desired value if multiple values exist???? njuneardave Excel Worksheet Functions 1 June 21st 06 08:32 PM
Count number of times two columns have desired values Gavin Deveau Excel Discussion (Misc queries) 2 June 16th 06 06:29 PM
HELP! - Printing a sheet with values populated from dropdown box Co-op Bank Excel Programming 5 July 13th 05 02:23 PM
sum values in a col only if value in next col is desired value u999rbm Excel Programming 3 January 16th 05 04:20 PM


All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"