Hi Praveen Thanks million!!
I looked at the code and modified a bit like this: I created a macro button on the tool bar and when I click the button, it get the value from the active cell and take it to the corresponding transaction in the other sheet. I thought this way it will prevent from accidental clicks.. The codes you wrote is very very very helpful and Iit was very interesting to know how to implement macro without clicking macro button but the cell. I think this will come very handy in the future (thanks a lot) I have been using macro for a while after reading a book for three times but sometimes I just doesn't have any idea where to start.. Um.. can I ask one more question please? As I explain above, there are three sheets. Now the second sheet and third sheet has a bit different. An ID from second sheet can point to the same ID in the third sheet but this time third sheet contains multiple rows with the ID. What I want is to have a new sheet created and extract these rows from the third sheet and from the second sheet. and copy them to the new sheet created so I can compare them.. Also if transactions in the third sheet are right next to each other then copy them as group so that there is no space. I need to find which one is the right one. For example, Let's say I am on C2 in sheet(2). I run the macro then I'd like to have a result like one in 'desired result' sheet. I think it's complicated. Could you help me? On Jan 17, 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 > > > > Select_data.xls > 49KViewDownload
-- ---------------------------------------------------------------------------------- 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
