Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm creating a workspace (on excel 2003) with three worksheets: active, inactive, and master-list. Tabs will move between active and inactive, based on whether or not I'm currently focused on them. I want the master-list to display the most recent entry from every tab that is currently on the active sheet.

Every tab on active/inactive looks the same (has the same columns and rows). I just want to aggregate all of my active data and still maintain the ability to move pages between active and inactive worksheets. I'm sure it can be done, but it's beyond my working knowledge of excel...

And help is much, much appreciated!

share|improve this question
    
I'm confused - what are these "tabs" that you have on each sheet? What are the "pages" you're referring to? Can you post a screenshot? – variant Jun 12 '13 at 17:56

You must log in to answer this question.

Browse other questions tagged .