No it isn't.
i can't understand. i downloaded your file and protect it with password. after protecting, searchable drop down list not working. it works as a normal drop down list. guide me please.
Posts by MudasGrid
-
-
It works. Just start typing in the cell - H3
It works because the sheet is unprotected.
-
It works for me whether the sheet is protected or not.
How ? Please ! I also want to learn.
-
Hi all !
Attached here a excel sheet in which a searchable drop down list is created. It works perfectly. But if I protect the sheet with password, the drop down list is working as a normal drop down list. What should I do now. Is there any solution of this problem ?
-
The VBA Code is Here
Code
Display MoreDim i As Integer Dim a As Integer Dim inv As Range Dim invds As Range i = 2 Set invds = Sheets("SALES").Range("G:Q") Do Until WorksheetFunction.CountA(invds.Rows(i)) = 0 i = i + 1 Loop Set inv = Sheets("INVOICE").Range("B11:L26") 'With Sheets("Invoice") 'Dim lastRow As Long 'Dim Rng As Range 'lastRow = .Cells(.Rows.Count, 1).End(xlUp).Row 'Set Rng = .Range(.Cells(11, 2), .Cells(lastRow, 12)) 'End With For a = 1 To inv.Rows.Count If WorksheetFunction.CountA(inv.Rows(a)) <> 0 Then invds.Rows(i).Value = inv.Rows(a).Value Sheets("SALES").Range("A" & i).Value = Sheets("INVOICE").Range("L6").Value Sheets("SALES").Range("B" & i).Value = Sheets("INVOICE").Range("L5").Value Sheets("SALES").Range("C" & i).Value = Sheets("INVOICE").Range("C5").Value Sheets("SALES").Range("D" & i).Value = Sheets("INVOICE").Range("C7").Value Sheets("SALES").Range("E" & i).Value = Sheets("INVOICE").Range("C8").Value Sheets("SALES").Range("F" & i).Value = Sheets("INVOICE").Range("L7").Value i = i + 1 End If Next a -
I am new here and also new in Excel VBA. After viewing different YouTube videos and online platforms I have tried to make this .xlsm file in excel to transfer Invoice data in another sales sheet. But there is an error and I can not rectify it.
I also want to transfer Invoice Grand total amount to Sales sheet.
Please help me.