I want to return a value from a cell on another worksheet which worksheet is sellected based on a value in the first row of the current worksheet. This page is an agregate of information organized by date. In the frist row I have a list of dates (one per week) and then there is a coresponding worksheet in this workbook for each date. Each week that worksheet is populated with the weeks numbers. I want to pull the week totals to a summation worksheet that can be combined with other info to make a chart that is updated weekly with the latest info. What is a formula to select the worksheet based on the value in row one of the column?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do I populate a cell with info from another worksheet, determined by a column heading on current sheet. Lookup?
Similar threads
- Solved
- Question
