When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side.
*My Hyperlink click and Jump Sheet 2 "Table 2"
(Table 1 location = Sheet 1)
My TABLE NAME IS = "Table 1"
Range name (B3:B8) = "ITEM_LIST"
How to possible This Query ??? Kindly Share...
Private Sub cmdSave_Click()
Dim LR As Integer, Master As Worksheets
Set Master = ThisWorkbook.Worksheets("Master")
LR = Master.Cells(Rows.Count, "A").End(xlUp).Row
If LR = 2 And Cells(LR, "A").Value = "" Then
LR = LR
LR = LR + 1
how to Get Stock Balance After check " CATAGORY NAME " WITH "PRODUCT LIST" and show result
- I was try but i was failed matching Product list with Category
Kindly Need formula this Query
# How get Sum value via "HSN Code" vise ??????
Advance Condition :
"if 100 or More Entries in sheets how it possible to solve query via Formula this Concepts "
(without pivotable / without filter/ without VBA)
I am trying to link two tables such that inputs to one automatically creates a new set of data in another.
I have a Project table that contains a list of projects and their data. The table is arranged in such a way that each project is one row.
I also have a Data table that feeds a...