98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Vba
Vba
Resolved · Medium Priority · Version 2007
Wed 14 Jul 2010, 16:04Delegate Steve said...
Steve has attended:
Excel VBA Intro Intermediate course
Vba
how do you click on a cell in a workbook and then view data relating to the active cell in an closed workbook located elsewhere on the network?
Thu 15 Jul 2010, 14:12Trainer Stephen said...
RE: vba
Hi Steve
Thanks for your question.
Could you clarify your needs for me. In particular, what data is contained in the cell you have clicked in and how is the related data to be identified?
Thanks
Stephen
Thu 15 Jul 2010, 15:28Delegate Steve said...
RE: vba
Thanks for the quick reply. For example, I may have a workbook with a column that contains Sales Order Numbers. There may be another workbook on our network that contains Information relating to manufacturing shortages for Sales Orders. I want to be able to select a Sales Order Number in a cell in the first workbook, and have the second workbook open, subfiltered to show only the shortages for the Sales Order in the selected cell.
Hope this helps
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |
