The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Vba

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Vba

Resolved · Medium Priority · Version 2007

ReplyWed 14 Jul 2010, 16:04Delegate Steve said...

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?

For upcoming training course dates see: Pricing & availability

ReplyThu 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

ReplyThu 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

Excel articles

· Create A Basic Timeline In Excel
· Do You Need To Run Excel 2007 In Compatibility Mode?
· Microsoft Excel's Best Kept Secret
· How to Create Better Excel Spreadsheets: Part Three
· Microsoft Excel Training Course

Please browse our web site to find out more about
excel software training and other Microsoft training courses.

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

How do you create macros