Re: $$Excel-Macros$$ How to create a link to other sheets...

2010-01-17 Thread kvc praveen kumar
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 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 t

Re: $$Excel-Macros$$ How to create a link to other sheets...

2010-01-17 Thread Markkim
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,

Re: $$Excel-Macros$$ How to create a link to other sheets...

2010-01-16 Thread Mark Kim
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 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 wrot

Re: $$Excel-Macros$$ How to create a link to other sheets...

2010-01-16 Thread Markkim
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 acci

Re: $$Excel-Macros$$ How to create a link to other sheets...

2010-01-16 Thread Mark Kim
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 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

$$Excel-Macros$$ How to create a link to other sheets...

2010-01-16 Thread Markkim
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