Hi all Wow.. I didn't know there is a place like this where you can get some help from experts for Excel macro.. It's brilliant.. !!
I have been thinking for some time that It would be very useful if I had this feature.. I hope it's possible. I have an excel file which has three sheets. First sheet contain a list of transaction and each of transaction has a unique ID and one of these transaction are related to the next sheet. Second sheet also contains a list of transactions and each of transaction has a unique ID as well. In the first sheet, I have a column that has a unique ID of transaction from the second sheet. For example Sheet 1 ID Company Product (ID from sheet 2) 1 A 3 2 C 1 3 D 2 Sheet 2 ID Product Company (ID from Sheet1) 1 X 2 2 Y 3 3 Z 1 As you can see above.. Sheet 1 and sheet 2 are related. What I need is .. when I click the cell which contains ID from sheet 2 in Sheet 1, I want excel to take me there.. so I don't need to look up in the sheet 2.. it will move there. or clicking the next cell.. so.. when I click 3 in the product column from Sheet1, I want to move to ID 3 in the Sheet2 and vice versa. I am not good at explaining.. I hope I make sense. I will be really appreciated if you could help me.. Thanks for reading..
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
