I didn't know how to summarize this in the title so please forgive me on that. I'm using Excel 2010 and I consider myself a decent Excel user though far from an expert. Unfortunately I think some people think I'm more of an expert than what I am. So here's my problem:
We have a spreadsheet that has two tabs. The first tab is a summary tab that takes data from the second tab, which is the "guts" where rows can be added/deleted, and data is entered.
Now here's the issue. The summary tab only has data from select columns from the more detailed tab. While the detailed tab has perhaps 30 columns, the summary tab has 10 or so. The challenge is to allow it so that when people go in and add rows in the detailed tab, it automatically populates the data from the new rows in the summary tab. I don't know how to do that. I've never known how to do make data automatically populate in another tab if a row is added.
Basically our managers want the detailed tab to be able to be played with as much as possible (rows added/deleted), with the summary tab just populating automatically when rows are deleted or added. I've only created these types of summaries when the rows are static.
Any idea how I can make it so this summary tab pulls the data from newly added rows and won't give an error when rows are deleted?
If screenshots are needed...I can provide. Thanks!
Bookmarks