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
