Linking Multiple Excel Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2392801%22%20slang%3D%22en-US%22%3ELinking%20Multiple%20Excel%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2392801%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Windows%2010%20and%20Microsoft%20365.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set%20my%20worksheets%20up%20with%20the%20following%20logic%3A%3C%2FP%3E%3CP%3EIf%20a%20County%20Provider's%20name%20changes%20in%20%3CSTRONG%3EColumn%20F%3C%2FSTRONG%3E%20%3CU%3E%3CSTRONG%3Eand%3C%2FSTRONG%3E%3C%2FU%3E%20it%20has%20the%20Code%2FModifier%20in%20%3CSTRONG%3EColumn%20C%3C%2FSTRONG%3E%20then%20any%20occurrence%20of%20those%20two%20things%20need%20to%20change%20in%20all%20worksheets%20in%20the%20workbook%20if%20the%20County%20Provider's%20name%20changes%20in%20Column%20F.%20I%20have%20attached%20a%20sample%20of%20my%20data.%20I%20have%20attached%20a%20sample%20of%20my%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2392801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2394283%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20Multiple%20Excel%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064895%22%20target%3D%22_blank%22%3E%40LaToyaM-000%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou've%20had%2039%20views%20and%20no%20replies.%20I%20am%20going%20to%20suggest--and%20I%20hope%20you%20can%20accept%20this--that%20the%20reason%20might%20be%20that%20your%20data%20is%20simply%20not%20organized%20in%20a%20way%20that%20allows%20Excel%20to%20do%20much%20with%20it.%20You've%20created%20a%20layout%20that%20is%20visually%20attractive%2C%20but%20not%20truly%20amenable%20to%20the%20kind%20of%20functionality%20that%20you%20appear%20to%20be%20seeking.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20it's%20also%20hard%20to%20know%20what%20the%20functionality%20is%20that%20this%20is%20meant%20to%20provide.%3C%2FP%3E%3CUL%3E%3CLI%3EWHY%20are%20there%20as%20many%20as%20three%20names%20in%20each%20of%20the%20boxes%20under%20the%20%22County%20Providers%22%20heading%3F%20In%20a%20well-designed%20data%20structure%2C%20each%20of%20those%20would%20be%20in%20a%20row%20of%20its%20own.%3C%2FLI%3E%3CLI%3EWHY%20does%20the%20tab%20for%20%22Group%201%22%20appear%20identical%20to%20the%20one%20for%26nbsp%3B%20%22Master%20Group%203%22%3F%3F%20That%20kind%20of%20redundancy%20doesn't%20make%20any%20sense%2C%20again%2C%20in%20a%20well%20designed%20data%20structure.%20You're%20asking%20that%20a%20change%20in%20one%20be%20reflected%20in%20the%20other%2C%20but%20why%20are%20there%20two%20to%20begin%20with%3F%3F%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20could%20you%20back%20up%20and%20tell%20us%20what%20this%20is%20all%20about%20in%20the%20first%20place.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am using Windows 10 and Microsoft 365.

I am trying to set my worksheets up with the following logic:

If a County Provider's name changes in Column F and it has the Code/Modifier in Column C then any occurrence of those two things need to change in all worksheets in the workbook if the County Provider's name changes in Column F. I have attached a sample of my data. I have attached a sample of my data.

2 Replies

@LaToyaM-000 

 

You've had 39 views and no replies. I am going to suggest--and I hope you can accept this--that the reason might be that your data is simply not organized in a way that allows Excel to do much with it. You've created a layout that is visually attractive, but not truly amenable to the kind of functionality that you appear to be seeking.

 

But it's also hard to know what the functionality is that this is meant to provide.

  • WHY are there as many as three names in each of the boxes under the "County Providers" heading? In a well-designed data structure, each of those would be in a row of its own.
  • WHY does the tab for "Group 1" appear identical to the one for  "Master Group 3"?? That kind of redundancy doesn't make any sense, again, in a well designed data structure. You're asking that a change in one be reflected in the other, but why are there two to begin with??

 

So could you back up and tell us what this is all about in the first place.

I had to remove PII from my spreadsheet before I uploaded. I have a user that sent me a spreadsheet with multiple names in the County Providers column. She requested that her spreadsheet be linked so that when one of the names in the County Providers columns changed, she wants that name to change in all of the other worksheets. The problem for me is that she only wants that name to change if it has that same Code/Modifier on the other sheets. I do understand that my problem is a bit confusing because the request itself was confusing to me. I just posted with hopes that someone could help. I appreciate you looking at my post and responding. I have come to the conclusion that perhaps my user needs to present her data in another way to achieve the results she would like. Thanks again for your feedback.