Print Dialog box
Is it possible in excel to create a box which will pop up when you click on a
cell so that you can type in a code and all details for that specfic code get printed out |
Print Dialog box
Maybe...
I would think that one of the easiest ways to implement the "box" would be to use data|validation (in the Data|Validation option in xl2003 menus). The list would be the leftmost column on a separate worksheet (nicely named!) and the other info would be in columns B:xx. Then you could use =vlookup()'s to return the associated values for that chosen option. Debra Dalgleish has some notes on data|validation starting he http://contextures.com/xlDataVal01.html And how to name that first column he http://www.contextures.com/xlDataVal01.html#Name Debra also has notes about =vlookup() he http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://contextures.com/xlFunctions02.html#Trouble ==== You may want to use a formula like: =if(a1="","",vlookup(a1,sheet2!a:x,12,false)) Where A1 is the cell with the data|validation value. And Sheet2 is the sheet with the table (A:X) and you want to retrieve column L (12th column in that range). False means that you want an exact match. Bunny wrote: Is it possible in excel to create a box which will pop up when you click on a cell so that you can type in a code and all details for that specfic code get printed out -- Dave Peterson |
All times are GMT +1. The time now is 03:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com