Determine selected cell excel

Microsoft Microsoft excel 2007 full vers...
June 14, 2010 at 23:41:40
Specs: Windows XP
I have a number of worksheets to give a 3rd dimension to my data i.e. Sheet 1 contains a matrix of towns showing freight prices between them at highest rate, Sheet 2 contains the same matrix with prices for the next (lower) rate and so on up to 9 worksheets.

What I want to do is click on a cell in the top matrix (Sheet 1) and pull values from the corresponding cell in the underlying 8 sheets and put them into a set of cells on the top sheet.

Is there a way to easily determine what cell is selected in the top worksheet that I can then use as a reference to grab data from the underlting sheets?

See More: Determine selected cell excel

Report •

June 14, 2010 at 23:47:47
JimmyCat, feel sure it can be done, sadly, I don't know how, you'll likely get more and more knowledgeable responses in the programming forum @:
Ed in Texas.

Report •

June 14, 2010 at 23:57:12
Thanks Ed.

Report •

Related Solutions

Ask Question