hlookups

[Bruce D.]

I am using excel 2007 and I have 2 worksheets. One is called data and the
other is called history. Both sheets contain account numbers and have the
same number of columns and headings. The difference is that the history sheet
contains all history records for the year vs the data sheet which just
contains records for the month.

I would like to be able to select a account number on the first sheet(data)
and have a drop down or pop up which shows all of the history records from
the second sheet(data). I don't think I am able to do this with a drop down
list or combo box. So I am thinking maybe some type of hlookup somehow. Any
ideas?

Thanks to everyone who replies!!

 

[John McGhie]

Hi Bruce:

You have posted in the Mac Excel group.

Excel 2007 is over there...

http://www.microsoft.com/office/community/en-us/flyoutoverview.mspx


Cheers

I am using excel 2007 and I have 2 worksheets. One is called data and the
other is called history. Both sheets contain account numbers and have the
same number of columns and headings. The difference is that the history sheet
contains all history records for the year vs the data sheet which just
contains records for the month.

I would like to be able to select a account number on the first sheet(data)
and have a drop down or pop up which shows all of the history records from
the second sheet(data). I don't think I am able to do this with a drop down
list or combo box. So I am thinking maybe some type of hlookup somehow. Any
ideas?

Thanks to everyone who replies!!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]