I have a worksheet with two tabs. The two have four columns in common. One tab contains Places visited and the other has details about the places. I enter the places in the first sheet and it is automatically gets populated in the second sheet. The problem is that the second sheet has data four common columns as sheet 1 plus other details about the place and if there is a new place added it messes up the second sheet is I sort it. Is there an elegant solution without the need for me to type in common columns in two separate sheets and automatically link to correct rows. See attached sheet
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Linking two tabs based on common columns
- Thread starter rameshjey
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,585
- Office Version
- 365
- Platform
- Windows
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Linking two Excel tabs using common columns
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Linking two Excel tabs using common columns
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Upvote
0
Similar threads
