Vba

Resolved · Medium Priority · Version 2007

Wed 14 Jul 2010, 16:04 Delegate 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:12 Trainer 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:28 Delegate 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips