vba & excel

I am reposting this, as I have not had a workable response - probably due to me not describing the problem eloquently. I have a excel file with 2 sheets. Sheet 1 has "Job Number" in Column C, and empty cells for Invoice numbers, in columns M, N, O, P, Q and R Sheet 2 has a dump from an...

Hi, I want to web scrape information to an excel worksheet for multiple pages. example from page 1 to 3. I tried a code found online from googling but it sends out an error. Any help is much appreciated. Thanks in advance. :) I would like to sort the information like the example shown below...

The codes open a Email find but can`t seem to grab any files? Private Sub Email_Files_Click() Dim objol As Object Dim objmail As Object Dim objFolder As Object Dim fso As Object Dim fsFolder As Object Dim fsFile As Object Dim strFolder As String...

what is the point of adding another tab if the previous line does it after each cell? Dim fso As Scripting.FileSystemObject Dim ts As Scripting.TextStream Dim r As Range Dim ColumnCount As Integer Dim i As Integer Set fso = New Scripting.FileSystemObject ' Open...

Need help building a code. I want to search all worksheets in a workbook that contain a specific string in its sheet name to copy cell data of a range and paste as values into a different ws. What I ultimately need to do is take data from A2 of all BL ws and paste into Column A of Summary ws...

HI I would like to combine two VBA codes but 1 works the other one does not :( I need the first code to monitor the two columns in the last code. Hope someone can help Dim xRg As Range Dim xChangeRg As Range Dim xDependRg As Range Dim xDic As New Dictionary Private Sub Worksheet_Change(ByVal...

I am trying to do macro automation for the following 3 tasks and I'm stuck in all 3 tasks, kindly request to help. Calculate ageing of tickets using assigned date of ticket Fill blank cells for which ageing calculation wasn't done due to an incorrect date format issue Refresh pivot tables...

Hey all, I'm doing some data analysis work on a bunch of spreadsheets and I'm seeking a way to automate part of the process. The entire row is highlighted based on the string value in column I, there's many different string values I'll need to create rules for. The longest string I've counted...

I've developed a simple user form with a bunch of buttons that, when pressed, play a sound. I've also assigned a custom "accelerate" key to each button in a manner which when I press Alt + key the button is activated. The problem is, this happens only once for each button! Every subsequent...

Hi, I'm searching for a way to let a sheet remember what the previous value of the cell when it changes. I found a code that does this on this forum, and I am able to change the destination cell and the column it needs to monitor. The wish is to let it watch two columns and save it in two other...

i need to create a macro to skip actions if their id matches to the list in another sheet in that excel for example something like : if Actions.setid matches id in sheet2 then I need to skip to next action For Each action In Enable.ConnectActions If Action.setid IN (sheet2)

I want to make a filter to show in a listbox all the coincidences with the text write in a textbox. and set focus in the coincidence. How can i do it? Here is my file LINK TO FILE Thanks for youre help

Hello, Really hoping someone can help me because I'm puling out my hair trying to solve this and getting no where fast. I have a PivotTable and one of the filters is for 'Vendor Name'. I can select a vendor then click a button I made and it fires them off an e-mail full of details which have...

I have a macro: Private Sub Worksheet_Change(ByVal Target As range) Dim v, cell Set Target = Application.Intersect(Target, Me.Columns(1), Me.UsedRange) If Target Is Nothing Then Exit Sub For Each cell In Target.Cells v = cell.Value If VarType(v) <> vbDate Then...

Hi guys, I wonder if somebody could help me with this. Using data validadtion I would like to have the Help button open a message bpox of whatever code I would attach to it instead of going to the Microsoft page. Is that even possible? Thanks in advance, I'm using Excel 2019

I have a workbook "Test" with sheets "A", "B", "C" etc. I am looking to move each of these sheets and save them in the same location as workbook "Test" using a file name from a cell in the sheet. I am trying to use the following code for the above that I found in one of the MrExcel threads: It...

I have VBA code on the Worksheet that records When, Who, and What Cell is changed when someone updates information in a row on the workbook spreadsheet. The code works well. I'm looking to start recording additional changes to each row, not just the last change. I've figured out how to use...

Hi Gurus, Good day! I just wanted to ask for your insight as I found a code to merge accounts, however if the cell data is not the same, it will skip the code. Example: No Name Data 1 Data 2 001 Math 100 95 002 Math 100 95 003 Science 95 90 'VBA Code for Merging the Data 1 and...

Hi everyone, I defined a ActiveX ComboBox named "cmbPeymankar", a Text Box (ActiveX control) called "txtNewPeymankar". a Command Button (ActiveX control) called "Add". I have a table named "Table1" in sheet "DATA" so that the first column of Table1 contains the names that should be displayed...

Hi Gurus, Good day! I just want to consult if there's a VBA way to combine the data (get the sum) of specific accounts? For example I have long list of data but need to combine the total data for Math & Science. Note that there are negative numbers sometimes and Reference 01 is the main...