Tech Support Guy banner
Not open for further replies.
1 - 5 of 5 Posts

· Registered
140 Posts
Discussion Starter · #1 ·
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!
1 - 5 of 5 Posts
Not open for further replies.