temp

hi, I am trying to populate a drop down box with a column of dates and only want to populate unique values. I have tried the following code but it doesn't work. Can anyone please assist? Sub FilterUniqueData() Dim Lrow As Long, test As New Collection Dim Value As Variant, temp() As...

I have found similar topic that deal with copying an entire sheet in one workbook and pasting it to a NEW sheet while the value on the specific cell increments and adds to the name of the new sheet created. However, the code provided was incomplete and missed the copying of the entire template...

Excel 2013 Layout: Cell A1: stores the network drive letter (currently set as P:) Cell A2: stores the name of the file (currently set as Test.txt) Row 4 has column headings: 1st Value, 2nd Value, 3rd Value Rows 5 to forever, but only Columns A, B & C have data in them. Currently I just...

So I have this function that returns a value from a web page. The issue with this is that it works perfectly when I run it single step, but when I run it normally it returns another value. Aditionally, the last line of the code, "objIE.Quit", does not run only when I run the program normally...

Hello All! I'm hoping someone can please help me with a formula that used to work back in 2015 but now I need it again and it's not quite working right and I've lost too many hours trying to work it out. This is what I'm failing to achieve. Here's an example to give you an idea of the...

Hi Having used this board before I am sure this will be pretty simple for someone on here but I just can't figure it out! I have the following columns; 'Working Month' (e.g. January 16), 'Membership Number', and 'Worker name', 'Agency Type' (Temp or Perm are the only two values,. On a summary...

I have this extensive and huge model that has run multiple times without issues (macro runs). Every so often it crashes stating "Microsoft excel has stopped working, windows can check online for a solution and recover your information". The last time I experienced this, a solution was to start...

Sub Swap_Values() Dim Temp As Double ThisWorkbook.Worksheets("JV").Activate Temp = Cells(9).Value Cells(9).Value = Cells(11).Value Cells(11).Value = Temp End Sub can any one help mw with this code row9 row10 row11 i want row9=row11 row11=row10

Hi everyone, can i ask is it possible to create a temporary database in MYSQL , create the required tables in it, link them (all via VBA) and then populate them? I need to delete the temp database (if it exists) before creating the new one. Does anyone know how to do this?

Dear All, I'm beginner in VBA and I've been trying to solve this for 2 days... I have a problem with the continue typing in combobox with search option in userform. The thing is that when I type a letter first match is autmatically a value of combobox and I can continue typing from the end...

Hello Everyone I am studying the VBA and looking for this code about sort number .I think so much but did not understand .maybe i am stupid! ............. Dim i As Integer, j As Integer, temp As Integer, rng As Range Set rng = Range("A1").CurrentRegion For i = 1 To rng.Count For j = i + 1...

Hi Sir, I am beginner in excel macro. I am able to use the macro recording. In recording we will get the formulas as is So, instead of that I want define VBA codes. So, Please help me defining the below formulas, =CONCATENATE(C2,"-",D2) = VLOOKUP (G2,'MASTER TEMP TL'!E:E,1,0) =...

I have a workbook where one of the sheets (Data) contains many rows and a few columns which multiple co-workers need to access to add new rows and also do searches by filtering. To prevent messing with the underlying data, I've created a button on the ribbon that copies the sheet Data to the end...

How do I get cell BA to show blank instead of False when Column AT is blank? =IFERROR(IF(AT6="Low Temp. (-10-10°F)",VLOOKUP(AY6,Codes!CP3:CV33,6,FALSE),IF(AT6="Med. Temp. (33-41°F)",VLOOKUP(AY6,Codes!CP3:CV33,4,FALSE),IF(AT6="Air...

hi im trying to optimize the following code: Function VLookLike(txt As String, rng As Range) As String Dim temp As String, e, n As Long, a() Static RegX As Object If RegX Is Nothing Then Set RegX = CreateObject("VBScript.RegExp") With RegX .Global = True...

I need to execute a stored procedure from SQL Server into Access 2013 and add the results to a temp table. I will then be using the data in the temp table to perform multiple calculations and prepare different reports. I thought using a Pass through Query would be the best way. The following...

Hello I got this from Here vba code to find exact or nearest match and return that match in new column It works very well, but I need for it to match only on the full name e.g txt string = Bob Boberson, Ph.d , XYZ r in rng = Bob Boberson, LLC To match only on "Bob Boberson" i.e to match only...

this code finds 2 non hypotenuse sides that form a right angle triangle then checks if it is a multiple of a previous "find". it finds nothing after 65 72 97 ie it does not find 65 156 169. J column is a list of prime numbers below 100 Sub Macro4() ' ' Macro4 Macro ' Macro recorded...

I am trying to save the results of a query called qry_RosterBase to a temporary table called tbl_TempForRoster. The query formats data from the Personnel Table for the Roster report. I am hoping that the numerous queries required to generate the Roster report will run faster by referencing...