Looking for GST HSN and SAC Codes related Formula in Excel 2021

Dear Gabriel-N

Thank you for your loving reply and here is the screen shot of the excel sheet as you requested. I posted here, as there there is no any confidential matter as of date, for our loving community so that all will have an idea of my unmature idea.

Thank you.

Hi RK Tenali

Thank you for your response. I wasn’t able to find the attachment you mentioned. Could you please attach the screenshot or file again? If it’s easier, you can also share it via the private message I’ll send you shortly.

Hi RK Tenali, thank you for your patience!

Actually, I'm halfway through solving this, but it might have taken too long for you to wait so I’d like to offer a practical solution instead.

1. Merge the Code Tables Copy and paste the contents of SAC_MSTR and HSN_MSTR into a new worksheet named Master_List. This will allow you to filter descriptions across both SAC and HSN codes in one place.
2. Add a Search Button Insert a button next to cell P1 using the Developer tab. If you don’t see the Developer tab:
   • Go to File > Options > Customize Ribbon
   • Check the box for Developer and click OK
   Name the button Find as Description > new.
3. Paste the VBA Code

Sub FindasDescription()
  
Dim MasterSheet As Worksheet
Dim InvoiceSheet As Worksheet
Dim searchKeyword As String
On Error Resume Next
Set MasterSheet = ThisWorkbook.Sheets("Master_List")
Set InvoiceSheet = ThisWorkbook.Sheets("Main") ' Change sheet name if needed
On Error GoTo 0
If MasterSheet Is Nothing Or InvoiceSheet Is Nothing Then
   MsgBox "Error: Could not find the sheet 'Master_List' or 'Main'. Please check again.", vbCritical
   Exit Sub
End If
' Read the search keyword from the 'Main' sheet (cell P1)
searchKeyword = CStr(InvoiceSheet.Range("P1").Value) ' Change cell P1 if needed
If Len(searchKeyword) = 0 Then
   MsgBox "Please enter the description keyword you want to search for into the search box", vbInformation
   InvoiceSheet.Range("P1").Select
   Exit Sub
End If
' Activate the Master_List sheet
Application.ScreenUpdating = False
MasterSheet.Activate
' Always clear the old filter before applying a new one
If MasterSheet.AutoFilterMode Then
   MasterSheet.Range("A1").AutoFilter
End If
MasterSheet.Range("A1").AutoFilter Field:=2, Criteria1:="*" & searchKeyword & "*"
Application.ScreenUpdating = True
End Sub
 

Save the code and also save the file as .xlsm to enable macros.

How to Use It

• Each time you open the file, if you see a yellow security warning, click Enable Content to activate macros.
• On the Main sheet, type a description keyword into cell P1.
• Click the Find as Description button.
• Excel will automatically switch to the Master_List sheet and filter the list to show only rows that match the keyword in P1.
• You can then choose the appropriate code and copy it back to the Main sheet.

Hope this helps you at least a little bit!

If you need any further support, don’t hesitate to reach out.

Dear Gabriel-N

Thank you so much for rendering your valuable time and hard work in helping my issue resolved.

I am doing the same as you suggested above by pasting the HSN and SAC codes in column A and their descriptions in column B in a new sheet and Titled it as Master_List. But I got into a little bit confusion when you said to Add a search Button Insert a button "next to cell P1". Do you mean "P2" or "Q1" and it should be created in the same Master_List sheet or elsewhere?

And I can not find any "Search Button" in Developer Tab. Pls let me know where I can find it.

Pls confirm the same and I will do accordingly and let you know the result.

Thank you

RK

Hi RK Tenali,

Regarding your questions:

1> I am doing the same as you suggested above by pasting the HSN and SAC codes in column A and their descriptions in column B in a new sheet and Titled it as Master_List.

Use Ctrl+A to select and copy the entire table, then paste it directly so that the second table connects to the first without any empty rows.

2> But I got into a little bit confusion when you said to Add a search Button Insert a button "next to cell P1". Do you mean "P2" or "Q1" and it should be created in the same Master_List sheet or elsewhere?

And I can not find any "Search Button" in Developer Tab. Pls let me know where I can find it.

Sorry for not double-checking the comment earlier. I’ve added the image again to show the visual setup, in case it disappeared previously.

You can draw the button as shown in the image. Once placed in the "Main" Sheet:

• Right-click the button to assign a macro, then paste the VBA code.
• Right-click again to edit the button text and label it as “Search.”

Let me know once you’ve completed these steps or if you need any further support, I’ll be happy to help.