I have two associated sets of table data that I need to find a method to create Excel linkages for, as the data is changing, so the associations change as well.
Example is attached.
The usual suspects (lookup, etc) do not seem to apply well to this type of variable dimensioned problem.
Any ideas?
Re: Link two related tables accounting for changing associations in data
Hello dhock194,
Welcome to Ozgrid.
To get the most precise answers, it is best to upload a sample workbook (sensitive data scrubbed/removed) that shows a few manually created examples of the desired results.
The structure and data types of the workbook must exactly match that of the real workbook. Include in the workbook a clear and explicit explanation of all requirements.The sample workbook only needs to contain enough data to illustrate the need to aid with developing the solution.
[COLOR="navy"]How to edit your post or thread title or upload an attachment[/COLOR]
1. Click the EDIT POST in the gray band immediately below your post
2. Click Go Advanced
3. Edit the post or thread title
4. To upload: scroll down to Manage Attachments
Re: Link two related tables accounting for changing associations in data
Excel 2010, Tables, PivotTables
Reconcile two dynamic, related Tables to each other.
With macro.
http://c3017412.r12.cf0.rackcdn.com/04_19_11a.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Re: Link two related tables accounting for changing associations in data
Thanks! Will this work with earlier versions of Excel?
Don’t have an account yet? Register yourself now and be a part of our community!
