Home |
Search |
Today's Posts |
#1
|
|||
|
|||
When Excel workbook starts I want to ask a question first
Thanks for trying to help....
When a coworker opens an Excel file, I want Excel to first have the person enter a number... Once the number is entered, that number is matched from column A and the sheet will only display the contents of that matched "row". Am I making sense? We just don't want to open the spreadsheet with all that data in thier face and have them search for their own stats. Again thanks! |
#2
|
|||
|
|||
Hi Steve,
Probably a couple of ways, depending on how the data is assembled. Perhaps a combination of a drop-down list with the numbers and a vlookup formula. Or a worksheet change event macro. One an auto open asking the user to enter a number in A1 and a worksheet change event macro to display the data. Mostly need to know the sheet configuration etc. I'd be glad to give it a go if you would send me a sample worksheet. HTH Regards, Howard "Steve" wrote in message ... Thanks for trying to help.... When a coworker opens an Excel file, I want Excel to first have the person enter a number... Once the number is entered, that number is matched from column A and the sheet will only display the contents of that matched "row". Am I making sense? We just don't want to open the spreadsheet with all that data in thier face and have them search for their own stats. Again thanks! |
#3
|
|||
|
|||
can send you an example... got mail?
"L. Howard Kittle" wrote: Hi Steve, Probably a couple of ways, depending on how the data is assembled. Perhaps a combination of a drop-down list with the numbers and a vlookup formula. Or a worksheet change event macro. One an auto open asking the user to enter a number in A1 and a worksheet change event macro to display the data. Mostly need to know the sheet configuration etc. I'd be glad to give it a go if you would send me a sample worksheet. HTH Regards, Howard "Steve" wrote in message ... Thanks for trying to help.... When a coworker opens an Excel file, I want Excel to first have the person enter a number... Once the number is entered, that number is matched from column A and the sheet will only display the contents of that matched "row". Am I making sense? We just don't want to open the spreadsheet with all that data in thier face and have them search for their own stats. Again thanks! |
#4
|
|||
|
|||
|
#5
|
|||
|
|||
Thanks for your help, but I knocked it out!! Only two macros needed! Thanks.
"L. Howard Kittle" wrote: Send to "Steve" wrote in message ... Thanks for trying to help.... When a coworker opens an Excel file, I want Excel to first have the person enter a number... Once the number is entered, that number is matched from column A and the sheet will only display the contents of that matched "row". Am I making sense? We just don't want to open the spreadsheet with all that data in thier face and have them search for their own stats. Again thanks! |
#6
|
|||
|
|||
Hi Steve,
Great, you made it work. For fun I would like to see your solution. Just to see if I was on the right track. Regards, Howard "Steve" wrote in message ... Thanks for trying to help.... When a coworker opens an Excel file, I want Excel to first have the person enter a number... Once the number is entered, that number is matched from column A and the sheet will only display the contents of that matched "row". Am I making sense? We just don't want to open the spreadsheet with all that data in thier face and have them search for their own stats. Again thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a workbook be opened w/out Excel on the host machine?? | Excel Discussion (Misc queries) | |||
Problem using excel workbook in word mailmerge | Excel Discussion (Misc queries) | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
Create invoices from excel workbook | Excel Worksheet Functions |