Search results

Thank you Iqubalind for your post. It seems to me that you want to look for the HSN number corresponding to a PARTICULARS. You can easily do that using the VLOOKUP function. I have used the following formula to do that: =VLOOKUP(E4,$B$3:$C$15,2,FALSE) If I missed something, please don't...

Dear Pisto, I'm glad to hear that my response was helpful. It's great that you're willing to dive into VBA to solve your task. Your approach to using MATCH or similar functions to check for "no" values and reporting them back sounds like a good plan. If you have any questions or run into issues...

Dear Pisto, Thanks for providing another screenshot. Unfortunately, I could not use any 3D reference formula as it would not be dynamic. However, I have written a custom VBA Function that will compile all the student names present at least once across all the sheets. From your screenshot, I...

Dear Karan, We actually have a great article and a video tutorial that might be just what you're looking for. I've included the Excel file from that tutorial which has a UserForm that allows you to enter various details like names, designations, and even photos of your employees! And the best...

Dear Pisto, From your provided screenshot, it's difficult for me to offer a solution without knowing how the other sheets are organized. Do you have separate columns for attendance and homework, or is everything in one column? To help me better understand the context, could you share a sample...

Glad to hear that! It was my pleasure to help you. Aniruddah Team Exceldemy

Dear SherriM, Thanks for sharing your file with us! I was able to figure out what was causing the issue and fix it for you. Previously, the code on Sheet3 was not properly determining the last cell of the CustRange. I have changed the code so that it can now properly enter the value from the...

Dear Sherrim, Can you share your file with us as we are having difficulties understanding the context clearly? In your post, you said you used a drop-down list (i.e. Data Validation) on the Customer column of Sheet1 and used a Named Range on Sheet3 as the Source List (I assume it is the Customer...