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 ..
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 ..