[The G-man]

Hi all,

I have a workbook with two worksheets in it. I have an entry worksheet and a worksheet that I want to display the data I've entered on the entry worksheet. Basically all I want to do is to have a cell value on one worksheet display the data from the other worksheet where it equals the correct date which is in a column and correct location which is in a row. For example:

The data entry worksheet

9-Mar 10-Mar 11-Mar
Location 1 1 2 3
Location 2 4 6 8

I want the other worksheet to display data that corresponds to a specific date and location that I choose. I am familiar with vb and input boxes. I want to input a date and location have the macro go through and find the specific date and location value and place that value in the cell on my other worksheet.

I know this is asking alot but I'm sure it's doable. If anyone has any suggestions, I would be very greatfull!

Thanks to all who read!

 

[The G-man]

sorry about the way that example posted. the columns are the dates such as 9-Mar and the rows are Location 1 and Location 2.

 

[Anne Troy]

Try using a combination of Index and Match, as described here, G-man:

http://www.excel-vba.com/e-formula-index-match.htm

 

[The G-man]

That is exactly what I needed!

:up:

 

[Anne Troy]

Way cool! Marking Solved.