Count Patterns In one Cell Excel

I wanted your help, I'm currently working in extracting some data, now the thing is that I have to count an specific amount of Call IDs a call ID format is the following 9129572520020000711. The pattern is 19 characters that starts with 9 and ends in...
more »

2017-08-15 23:08 (3) Answers

VBA - Simpler Code for Formatting

I was hoping that there is simpler code for my formatted cells below. The goal of this code is to make a box look a bit nicer, nothing overly fancy, just simple and this code doesn't look simple. Range("C17:C25").Select Selection.Borders(xlDiagonal...
more »

2017-08-15 22:08 (2) Answers

FROM keyword not found where expected Error in SQL

I've been working with our coder from another office over email, and we've hit a bit of a stand still with this code. I keep getting oracle errors whenever I try and execute the query. Below is the code I'm using: SELECT TALLY_TRAN_MSTR.SHIFT_DT, TA...
more »

2017-08-15 20:08 (1) Answers

VBA excel convert value

I am using a connection to a CSV file to get the information in a XLS macro file and I am having the issue with this query: DataQuery = "SELECT [LastName], [FirstName], [BadgeNum], IIF(IsNull([CaseDocs]), 0, [CaseDocs]),IIF(IsNull([CallCount]), 0, ...
more »

2017-08-15 20:08 (1) Answers

Filtering Data from a Query with SQL

I'm really running into issues with this SQL code I'm using. I've been posying about this, but not really getting answers. I tried to adapt this code to what I am trying to do, but I keep getting the screen shot of the error message screen grabbed be...
more »

2017-08-15 16:08 (2) Answers

hide column based on cell font color in a row vba

I am trying to hide columns based on cell font color in first row. Here I want to hide columns if cells in first row has black as font color. Now, I dont want to define a range since my data varies each week so I can have 10 columns this week and 20 ...
more »

2017-08-15 15:08 (3) Answers

Before CheckIn-Event for Excel

I have an excel file on sharepoint which is to be checked out to make changes on it. These new changes should be exported to an access file, which is not part of the problem. The problem is that the code for the export to an access table should start...
more »

2017-08-15 12:08 (0) Answers

Delete table name in Excel VBA

I would like to remove/delete the name of my table which is "Table2" using Excel VBA. I know how to remove the name by hand, but I cannot figure out how to set the name "Table2" as a name in VBA. I found other questions on this topic but those codes ...
more »

2017-08-15 10:08 (3) Answers

Excel time comparison

I have given workers' start/end(coming to work and going out from work times) time in excel table. In 2nd table, I have given breakfast, lunch, dinner start/end times. How can I check worker can eat breakfast, lunch, dinner? ...
more »

2017-08-15 10:08 (1) Answers

Filtering Data based on calculation in Excel

I have data coming in from a query. I originally filtered the data with SQL, but I'm not sure if what my boss would like me to do is possible in SQL. I would like to tally the value in column C if "LOAD_BEER" is in Column D. Group data by Person (C...
more »

2017-08-14 20:08 (1) Answers

Speed up Excel Macro as Opening

So the whole scope of this Excel file is to copy and paste from other 27 external files to the current Excel file one by one. to show what I mean, following are the code examples and a stimulated capture picture. Macros(line # including space line):...
more »

2017-08-14 18:08 (2) Answers

FOR loop in Excel - find and replace

I have the following code Sub CleanCat() Dim i As Integer For i = 1 To 50 Columns("A").Replace What:="Cat" & i, Replacement:="Category" & i, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=F...
more »

2017-08-14 17:08 (2) Answers

Deleting a Row in Excel if Value is less than X

I'm trying to delete a row in excel if it meets the criteria that the value in Column B is less than 100. I saw this and tried to follow it, but I'm not that knowledgeable in VBA, so I'm not sure where to go. EDIT This is the code I've tried thus f...
more »

2017-08-14 15:08 (3) Answers

Logic issue at the end of a loop

I have a spreadsheet with a column filled with strings. There are sometimes several instances of one string (I've sorted it though so they're all grouped together) so I've created a macro that looks at the current row in the column, determines if its...
more »

2017-08-14 15:08 (3) Answers

Excel VBA - Import Macro that works but doesn't

I have the following Macro - Sub Import_Data() Dim rng As Range Dim WB2 As Workbook Dim FName As String Dim ChampSpecific1 As Worksheet Set ChampSpecific1 = Sheets("Summary-Champion Specific") FName = Dir(Application.ActiveWorkbook.Path &...
more »

2017-08-14 14:08 (1) Answers

Input Data from a Select File using VBA

I work at a bank and we regularly receive quarterly Data from Nasdaq Smart about market abuse. I have been assigned with the task of creating a macro to summarize this data to be able to visualize market abuse over longer timelines. So far I am abl...
more »

2017-08-14 14:08 (2) Answers

VBA Excel Error Run-Time error '53'

I hope you can help. I have a macro and it is extensive. Essentially what it does is it has a User form See Pic 1 This user form allows a user to navigate to a template where data is stored (see Pic 2) and select this completed template. On the u...
more »

2017-08-14 11:08 (2) Answers

VBA filter by multiple cells

I'm trying to filter a list according to the values of multiple cells on another tab, but i just can't get it to work properly. This is what i got: ActiveSheet.Range("$A$2:$Y$129").AutoFilter Field:=13, Criteria1:=Range("Formulas!A8:A10").Value ...
more »

2017-08-14 10:08 (1) Answers

Error, in comparing two sheets

I have two sheets, S and P. I am trying to compare the Id between two sheets. IF I the ID matches the I pull the corresponding details of the matched ID and paste them in sheet3. For this task, First I copied the column containing the ID in my s...
more »

2017-08-14 09:08 (3) Answers