-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
fltr
-
Copy sht1 to sht2 based criteria (Script.Dictionary)
I need copy data to another sheet My tab("Relatorio") hava CFOP in column M, if find any value start 1 or 2 like this( <tbody> 1253/AA 1949/ZZ 2102/AA 2353/AA 2920/AA) </tbody> Copy to tab("Saida") case start like this( <colgroup><col width="64" span="3"></colgroup><tbody>...- marreco
- Thread
- copy dim entrada fltr val
- Replies: 3
- Forum: Excel Questions
-
S
1 Search Box for Multiple Fields
I have the code below linked to a text box on a Form. It searches 2 fields for the textbox value. Is there any way I can edit it so it searches for values which contain the textbox value? At the moment it is only searching or an exact match... E.g. If I search 'Test' it will not show 'Test123'...- SantasLittleHelper
- Thread
- chr$34 fields fltr search searches
- Replies: 4
- Forum: Microsoft Access
-
B
Querying AD information Through VBA Error
I have tried numerous ways to get this to work and keep getting an "atrribute syntax specified to the directory service is invalid". I am new to active directory and have never used nonrational database querying before. It seems to connect fine but after that no matter what I try it will not get...- balla506
- Thread
- active directory base fltr set vba
- Replies: 1
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
VBA ARRAY CODE HELP
- Started by roykana
- Replies: 31
Dear all master, Please help for vba array code remove numbers based on specific contents of cell. ORIIGINAL [ATTACH type="full"]41084[/ATTACH]... -
VBA to find values in several columns, based on common value in a different column, then copy paste to different sheet
- Started by mlepesant
- Replies: 26
Hello, New to the forum. Good excel skills but almost no VBA experience. I have a file that provides me with Bill of material for different... -
Can someone help me understand the differences between dictionaries and arrays
- Started by dpaton05
- Replies: 23
I am struggling to understand the differences between when you should use a dictionary as opposed to when you should use a dictionary. Can someone... -
Auto add last entered data in same row
- Started by Detectiveclem
- Replies: 57
Hi can anyone help with a formula which will allow the last date entered in a row to be captured in the last date entered cell (E.G. Cell A2) And... -
Error with Loop
- Started by Jeeremy7
- Replies: 22
Hello, I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ? Also I saw that some... -
Check a number is between two columns and then pick a value
- Started by ashok89jan
- Replies: 20
I have the data like given below till Low =0.5, High= 1.49, and Grade = 1 My need is, if I enter a number in a different cell, say 95, I need that...
