Hi All~,
I have two sheets in my workbook. One is "Invoices overview" and second one is "Invoices payments details".
My requirement is if I click on Invoice number, it has to take me to invoice payments detail sheet and display record for that invoice only ( Basically set a filter with click cell value).
Help will be appreciated.
Thanks,
Raja
Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your "Invoices Overview" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Click on any invoice number in column D.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you sir...Its working fine
You are very welcome.
when sheet is protected its throwing an error. is it possible to fix it?
Is it protected with or without a password?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks