excel vba 2016

Hi, could really use some help with this. (hopefully not as dumb as question as last time! I am trying to write a macro that will search through a load of sheets for a value in column L, and if it finds that value, copy the whole row (and repeat for all non blank rows in sheet) I will need to...

I am working on a simple spreadsheet that changes characters when you click on the cell, then counts the cells that are of a certain character. I have set the range to only look at certain cells (A3:A27, B3:B27) but anytime I click on row 1 (Row with several merged cells) or select multiple...

A simple sort routine is being used across a number of reports, but there's a few instances where the sort begins on the second row (row 13) and the not the first (row 12). It's strange, because the same code works fine in the majority of cases. Any ideas? Thanks in advance...

Hello, I got stuck on the following code that shows date selected from datepicker Private Sub select_label(msForm_C As MSForms.Control) '/* Capture the selected date */ Dim i As Integer, sel_date As Date i = Split(msForm_C.Name, "_")(1) - 1 sel_date = FirstCalSun(curMonth) + i...

Hi Friends, I have list of keywords in Sheet2AColumn like PHP A PHP B PHP C and so on. I need VBA to search keyphrase("PHP A") from Sheet2AColumn in search box and extract all autosuggestion urls into sheet1AColumn. I did search in forum posts here, but did not find a VBA code which does the task.

Hi Friends, Been through some of the posts related to wikipedia.org to extract data into excel. But did not find exact match to my need. I am looking to extract first paragraph of en.wikipedia.org article into excel sheet using VBA. Here is sample links I am trying to. I have huge list of...

Hi all i am new to Excel VBA and i need help in coming up with a macro to carry out a time consuming task. This is what i want the Macro to do when the Update data button is clicked: It should copy the information from certain columns (A,B and F for example) of worksheet 1 and "paste special"...

Hello, I have a code in which i use ActiveWorkbook.Queries.Add to import a CSV file. But while importing i need to filter only those rows containing value given by user. Below is the code. I have Highlighted and Bold the portion where i give the filter criteria as [Object ID] = 140. But what i...

hi all im new here and little noob with excel vba im trying to make a form system that i can use at my work to make my work much easier where i can collect information of my clients and what kind of installations they have on there building i have a userform with: Combobox1 (with text of...

Hi, I found this Macro to concatenate information base on the same project number and combine the different rows that contain the different roles per project. I am getting an error message Type Missmatch. xRes(I + 1, 2) = xRes(I + 1, 2) & ", " & xSrc(J, 2)Can anyone help? Thanks,Sharon Data...

Hi everyone, I'm currently working on a project where I want data taken from an excel table imported into an access database. The excel table cannot be linked to the access. This is the code I am currently using: Sub AccImport() Set cn = CreateObject("ADODB.Connection") dbpath =...

I have the following formula. It works for saving as a new workbook. How can I get it to work for saving as CSV? I have tried adding ".csv", FileFormat:=xlCSV to it but no such luck thus far. Cheers :) ActiveWorkbook.SaveAs Filename:="C:\User\Test.CSV" & Test1Str & " " & TestStr & " "...

Hello Hopefully very easy to fix.. I would like this applicable to all cells with C2:C10000 and D2:1000 So if in cell C3 I change the cell to Y, D3 would update.. Works fine at the moment but on a cell C2. Many thanks Private Sub Worksheet_SelectionChange(ByVal Target As Range)...

I am using VBA code in Excel 2016 to delete rows (on sheet "Data") that don't match criteria on another sheet (Column A, on sheet "Unique values") in Excel. However, the code only deletes selected cells in one column (C), so the remaining cells then don't match the original data in other columns...

i am looking for a vlookup VBA code for my project. i have Multiple sheets like sheet1,sheet2,sheet3,....upto sheet6 in these sheets i have different columns and a usernames column with different usernames. i have one more sheet7 in that i have only one column with fixed usernames now i want...

Hi, I need some help!! I am trying to put formulas in a few columns. Here's where the problem comes in, I am using variables to look for the column with the headers names. Cells(5,dis).select Price= Application.Match("List Price", .Rows(1), 0) Cost= Application.Match("Cost...

I am looking for some VB code for the following. I need to copy all of the data (values only) from worksheet 'extworksheet' in workbook 'extworkbook.xlsx' to worksheet 'localworksheet' in this (active) workbook. Literally replicate the 'extworksheet' into worksheet 'localworksheet' from cell...

I've written a small Sub that is really frustrating me. Sometimes it works just fine, other times I get the "Application-defined or object-defined error". I don't have any further information to give, sorry. I've thought about this one for quite a few hours now. For the sake of my sanity, please...

I'm trying to create a tracker based on the quotes that my employees are sending out to our customers. I'll need to have the information coming from their individual versions of the same quotation tool to a singular tracking workbook on a Box.com folder. I need the information inputs to be added...