Hi Praveen Thanks Million!!! This is exactly what I was looking for..
Thanks a lot !!! On Sun, Jan 17, 2010 at 1:35 AM, kvc praveen kumar <pkkara...@gmail.com>wrote: > Hi, > > Please find the attached file and let me know if this is what you are > looking for. I used worksheet events to impement the same. > Regards, > Praveen > On Sat, Jan 16, 2010 at 6:39 PM, Markkim <mark....@gmail.com> wrote: > >> 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 >> >> > > -- > > ---------------------------------------------------------------------------------- > 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 > >
-- ---------------------------------------------------------------------------------- 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
