• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Want to copy only a cell from one sheet

Aslam

New Member
Hey,

I need help guys,
I am attaching a file.
Theres a coloumn named ENTRY in BANK And BANK1 - If i type there D ..

If i type D in coloumn J and row 2 ie J2
I want is the first thing excel should do is copy B2 in the clipboard
and then search for C2 in sheets DEBTOR & CREDITOR both sheets in column I:I and take me there directly.

is there a vba code or excel function anything could help me ..
Please anyone could help me ..
 

Attachments

  • SAMPLE.xlsx
    15.2 KB · Views: 4
hi

check this macro..it is working for sheet bank, you can modify as you need...

cheers!
 

Attachments

  • DrCr.xls
    55.5 KB · Views: 3
Back
Top