Automatically Updated Worksheets

[Gunnerman8]

I have a workbook which contains several tabs. The source tab (A for purposes of this thread) can be sorted several ways. The different sorts are what comprise tabs B, C, etc. Currently, when I update A, I then have to go into the corresponding tab to update it as well. I would like to be able to just have to update the source worksheet, and have the other tabs automatically update themselves. I appreciate you taking the time to read this!

[Palmetto]

Likely there is a solution once you've posted a sample of your workbook and we can see the structure, references, etc.

[Gunnerman8]

I have attached a copy of a spreadsheet that illustrates my problem. What I would like to be able to do is edit the tab titled "Source", and have all the other tabs (which are all sorts from "Source") to update themselves accordingly. Currently I have to manually update each tab individually every time a change is made to "Source". Thanks!

[Gunnerman8]

Hello...I have not yet received an answer to the question I posted above. Does anybody have a suggestion?

[DrPips]

Hi Gunner,

What sort of changes will you make to the source sheet?

Dom

[martindwilson]

have a look at this, all names must be on all sheets though

[DrPips]

I had a go using a macro, but it didn't seem to work, not sure what I did wrong. Somebody with more expertise may be able to correct it.

Macro is:

Please Login or Register  to view this content.

Dom

[Gunnerman8]

Hello, all. Thank you for the replies thus far. I plan on making two types of updates/changes to the spreadsheet at hand. Firstly, I will be adding new names to the "Source" document, which I would like to be automatically added to the others. For instance, I would like to be able to add the following:

"Cindy CA Night A"

and have this information then automatically inserted into the corresponding tabs. In other words, after entering this new person into the "Source" document, I would like to be able to pull up the "Location - CA" tab and see that Cindy had indeed been added into the spreadsheet.


The second type of update/change I will be making will be to the existing data. I would like to be able to do the following:

Change Mike's location from NV to CA, and have the information in the Location tabs reflect this. My hope is that were I to change "Mike's" location from NV to CA, that I could go to the Location - CA tab and see that Mike had been added to this list as well as being removed from the Location - NV tab.

Thanks again!

[martindwilson]

ok heres just that, formulas go down to row 60 drag down up to 500 if you want formulas are arrays confirmed with ctrl+shift+enter