Sorry I didn't attach an file. hm.. not sure how to attach a file.
Hope this is ok.. On Sun, Jan 17, 2010 at 7:50 AM, Mark Kim <mark....@gmail.com> wrote: > 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
sample.xls
Description: MS-Excel spreadsheet
