Ask Experts Questions for FREE Help !
Ask
    mitank's Avatar
    mitank Posts: 8, Reputation: 1
    New Member
    		  
    #1

    Nov 25, 2008, 05:56 AM
    SpreadSheet Printing
    Let me be more precise

    None of my Sheets are Hidden not any cells are hidden.

    I have number of items in my dropdown list.
    I have created formulas for every item from the dropdown list so that if any item if it is selected it matches with other sheets in the same workbook and gives results.

    Currently I have to select each item individually, get the result and take a print out.

    Can it be possible that all the items in the drop box are selected, automatically the results are changed for each item and print out are taken in one click only.
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
    		  
    #2

    Nov 26, 2008, 06:09 AM

    If I understand correctly, this would take some significant macro coding to accomplish. However, you would have to provide someone a copy of the spreadsheet and spend a little time with them showing them exactly what you need.

    I'm sure some of the experts will be happy to assist you.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Nov 26, 2008, 06:27 AM

    I'm really not following what you want. A sample sp[readhseet attached to your post may help.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

SpreadSheet Printing [ 2 Answers ]

I am using Excel 2007 I have number of Items in my dropdown list and I need to take a print out of every item from the list. Is there any way to give just one print command and the entire list gets printed one by one instead of selecting each item separately and giving a print command.

I cannot save my spreadsheet [ 2 Answers ]

I have had this worksheet for 6 months and I have been building on it every couple of days today it would not allow me to save it, says memory is full ? This unit has very little on the hard drive and very little on he share drive I use o take back and forth between computers. The only...

Excel Spreadsheet [ 1 Answers ]

I need a macro or something for a website that has a excel spreadsheet. My client has a excel spreadsheet out on a website. They have invoice # on the excel spreadsheet and want to be able to scan the invoice and have it linked to the invoice on the website so clients can see the scanned document....

No spreadsheet [ 4 Answers ]

I have a new computer with windows vista. There is no spreadsheet with it like there used to be on computers. Is there a free way to get a spreadsheet system in my computer. I use spreadsheets some but not enough for me to buy anything to get it to work.

Possible to link a spreadsheet 2 way [ 7 Answers ]

I know how to do a "one way" link in a spreadsheet. For example, if you change the value in A1, you can make it automatically change the value in A2 also. However, is there a way, if you change the value A2 that it will also change the value of A1? Thus, whichever you change, A1 or A2, will...

View more questions Search