You are welcome Mark!! You can try doing that and let us know if you have any issues.
Regards, Praveen On Mon, Jan 18, 2010 at 3:41 AM, Markkim <mark....@gmail.com> wrote: > Thank you very much Praveen!! > > I would also like to do the same thing from the first sheet.. get > infor from the second sheet and the third sheet.. (sorry the idea > coming up as I think through).. but I will try it myself.. after > studying your code. > > Thanks again.. > > Have a nice day!!! > > On Jan 17, 6:17 pm, kvc praveen kumar <pkkara...@gmail.com> wrote: > > Hello Mark, > > > > Please find attached the result sheet. > > > > Select a cell in the *thirdsheetid column* in* sheet2* and then run the * > > desiredresult* macro. > > > > You will get a new sheet "*Desired Result*" with the data from *2nd > sheet*and > > *3rd sheet,* *for the cell value* you selected. > > > > Let me know if this helps. > > > > Regards, > > Praveen KVC > > > > > > > > On Sun, Jan 17, 2010 at 3:08 AM, Mark Kim <mark....@gmail.com> wrote: > > > 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 athttp://www.excel-macros.blogspot.com > > >>>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > >>>> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > > >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > >>> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://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 > > > > > > > > Select_data.xls > > 64KViewDownload > > -- > > ---------------------------------------------------------------------------------- > 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
