Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-19-2018, 09:37 AM
Rudi Rudi is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2012
Posts: 15
Rudi is on a distinguished road
Default Part-linking two worksheets


Hi


I have two worksheets, List and Quotes. The first two columns of both are linked ==> i.e., cell A1 in Quotes contains =List!A2, B1 contains =List!B2, etc. (It is A2 ... because List has a header row and Quotes hasn't). What I wanted to achieve is to simplify matters. Should I need to sort the values in List, the identical values in Quotes would automatically change too.


However, instead it has added a snag. The values in the C-columns in both worksheets are different but the ones in Quotes would need to stay with their respective cousins in A and B columns when they change positions when things change in List. Obviously, I cannot just enter =List!C2 in the column in Quotes so is there a way to do this, i.e. link different values?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
ComboBox linking in with other worksheets Shakeregg Excel Programming 3 11-04-2018 08:06 AM
Linking Workbooks/Entire Worksheets to Identical in Master taxacct Excel 2 10-01-2014 11:22 AM
Interactive worksheets on the web beingbobbyorr Excel 1 08-22-2011 05:32 AM
Linking text between worksheets AndrewsGram Excel 1 03-09-2010 01:26 PM
Help with worksheets on Word eballi Word 4 11-18-2009 05:17 AM


All times are GMT -7. The time now is 08:09 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft