vba & excel 2016

Hello, I am new to macros and struggling to get a desired range, two adjacent columns (A7,B7), to autofill to the last row of C. Another problem is that I have some data throughout columns A and B and I do not want to overwrite those. So I think I need a loop to get around that? <tbody> Title 1...

Hi I have the attached table. When user press submit button, I want to display the following message Based on the column C, "Add or Remove": Thanks for your license request. You have requested to add the following modules: Text1, Text3, and Text 4 (Quantity 5), Text 5 (Quantity 5) You...

I'm super new to VBA, so I'll try to explain thoroughly: I have a workbook where I enter data for a specific person in each tab. There's also a master tab that rolls up this data into averages. In order to add a new tab, I copy the tab, clear out the data, then I copy the row of formulas and do...

Hello, I have a button running three macros. I was to have this run through multiple sheets in a workbook, but not all the sheets. Just selected sheets. I have this code on the button. It seems to run through and select the sheets as the message box pops up. But it is not actually running the...

Hi, I have an Multi-Line ActiveX TextBox1 that has the below strings as separate lines: 'Cat' 'Dog' 'Snake' 'Bear' 'Dragon' I have TextBox1 linked to a single cell, so that it will output these lines to one cell. I'm trying to figure out a way (if indeed it's even possible) to output each...

I’ve inherited a transactional database that’s causing meproblems as there’s no governance around changing things… Fix #1 I guess! In the meantime, I’m trying to get a solution. What I need to build is a macro that can pull downloadeddata into a new sheet (I’ve got this already) It then...

Hi, I'm getting the "Run-time error '5': Invalid Procedure call or argument at the line below in blue: PT1.ChangePivotCache ThisWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=PTSourceRngFcst, Version:=6) These are the values of the cells listed in the code: G24 =...

Good day, I need VBA code to automatically insert a row below or inbetween rows based on criteria. In the example below, I need code to run row by row to check if the "OVER" column >0, if that case is true, it will check 3 conditions: 1) Check the "HOURS" column for the max hours such as 10.5...

Hi, I have a ComboBox embedded in a worksheet that references a list of items. Ie: small cat cat big cat small dog dog big dog Right now when I type in 'cat' i only get 'cat' as the suggestion. What I would like is to get all items that contain 'cat'., ie., in this case: small cat cat big...

Basically I'm just trying to convert a date and time to a different time zone. Here is my code: dateString = Left(startcell.Offset(i, 0).Value, 10) & " " & Mid(startcell.Offset(i, 0).Value, 12, 5) dateofPeak = DateAdd("h", -7, DateTime.DateValue(dateString)) The dateString input is "2018-06-02...

Hi All, Was directed here by someone after not being able to find a solution online. I have an Excel report that gets sent through to me every week and I always have to unmerge the top two rows so all headings are unmerged and then delete all columns containing the words "Ex VAT", "Inc VAT"...

I'm new to VBA in excel and I borrowed this code from a previous thread that has worked well. It takes each value from column B in my main tab and creates a named tab with the format of the CONTROL tab and hyperlinks it in the original tab: Sub CreateAndNameWorksheets() Dim c As Range...

I tried to search the forum, however did not get correct answer. Happy to get to correct link in case I missed it. I have a sheet in which user can select a value from drop down in column M. I want user to select either Y / N in column N if a value is selected from drop down in column M or...

Hi All, I'm trying to add a macro to a template that' proving tricky. Basically, the macro needs to go to cell "C4" then loop down a variable amount of times until it hits a blank cell, it then needs to add a blank row using the formatting from the above populated row without any data.

Hello everybody, I am trying to write VBA code to copy cells from a range of non-contiguous columns (A:K, O:Q) to a new sheet if certain criteria is met (a cell in columns O:Q is populated and cells in column F do not contain a key word). I am able to specify the criteria but the code I've...

Hi Friends, I have constructed list of Google CSE JSON API urls with keywords to extract Linkedin profiles data into excel. I have VBA script which can extract Google CSE ATOM results. But, unfortunately Google has change ATOM results to JSON API results. So, the script is not useful anymore...

Hi, I want to splits cells (text to columns) with a VBA Macro. I'm using the following code: Columns("A:A").Select Application.CutCopyMode = False Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote...

Hello, Below is the code that I am currently using to copy all the rows on each of the specified worksheets based upon a single criteria (Column N="Y"). The Marco then pastes these rows as values on Sheet 4. This code functions properly however, it is extremely slow. The verison of Excel that I...

Hi! Utilizing Ron de Bruin's code to email Excel range over Outlook in HTML, however could you guys help me understand the conditional formatting part. I want to focus on 3 columns in my range: E; F; G. I have conditional formatting in place for column G based on formula: =F3<>0 e.g. if column...

Sorry for the long post, any help is appreciated. I am working on the Macro below. I am hoping someone can provide a little guidance on a few questions. 1. Should the Marco be in Module1, The spreadsheet I am running it against or in ThisWorkbook? 2. I can run the solver without an issue...