We have an excel sheet which contains the following summary sections -
These summary sections are created based on the data available in 'Account Details' sheet.
We need to build a macro which upon execution (some trigger like cell change etc.) will create hyperlinks for each of the values in these 4 summary sections - for each cell column 'E' onwards.
Once the respective hyperlink is clicked, it should navigate to the 'Account Details' sheet and automatically filter the 'Account_Details' sheet based on the criteria that matches the cell which is clicked in that particular Summary.
The macro should be made generic, as the rows in 'Account_Details' sheet will vary. However, the structure of summary sections will remain same.
Attaching sample '[login to view URL]' file for reference.
1. Freelancer should be from India.
2. Freelancer should have GSTIN.
11 pekerja bebas membida secara purata ₹6948 untuk pekerjaan ini
Dear Sir, I have a solution for your problem. But I have two question. 1. Why do you prefer freelancers from India. 2. Why do you need my GSTIN number.
Hi. I have ample experience with visual basic for applications using Microsoft Excel. I think I can create the macro you want. Please, send me the details and I will tell you if I can do it or not. Thanks.