Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Auto-adjusting spreadsheet in Excel

  • Please log in to reply




  • Member
  • PipPip
  • 88 posts
I have a question for those Excel wizards out there, see if this makes any sense.

I have an Excel workbook with multiple spreadsheets. Each spreadsheet has a different list of items with multiples columns (with headers) for various values including dates and text info. These spreadsheets represent the status of a particular file so for example, one spreadsheet lists files that are currently active, another lists those that are outstanding, and another has those that are closed. Each spreadsheet utilizes the same headers in the same order, allowing me to transfer items freely from one spreadsheet to another without needing to rearrange info in it's row. What I want to do it create a master sheet that automatically combines all items and their info into a single list, automatically updating the information and values manually entered in the individual spreadsheets. Personally I would easily be able to do this if the values were not constantly being updated daily, but they are. In addition I routinely move items from one spreadsheet to another based upon their status. If this sounds like something that is not feasible please let me know and if you can offer a suggestion for an alternative I would certainly like to hear it. Thanks!

Edited by Zook, 17 January 2014 - 11:25 AM.

  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP