LOOKUP Entire Table in Another Workbook

Hello all,

I'm new to the forums and this is my first post. I tried to look for an answer myself using the search, but the 30 second delay is less than conducive for finding the answer in a previous thread and has motivated me to simply start a new one.

What I'm looking to do is simple. I have one excel file that can be edited by a team of 3 users. It has a single table with ~30 rows and 6 columns. I have a computer with a large monitor attached. I call this a project board. I want to display the contents of the excel table and have it refresh every 30 seconds. So if a user makes a change in the main table, it will appear on the project board within 30 seconds.

I am no Excel genius by any means. I tried VLOOKUP and HLOOKUP and each seems to return a single value. How can I return the entire table?

Thanks in advance!
-DaMan

No help yet?

I guess it's more complicated than I thought