excel-vba

Guys, I have some macro that filters all the data (250 rows) by one column, then deletes the data that is hidden after filtering. Next step is unfiltering whole sheet using ActiveSheet.ShowAllData. What's strange, on my machine after unfiltering my used range seems to be 200 rows (50 rows...

So I created some code that will allow a user to enter multiple pages of data and then just click a print button to click the number of pages of data he has entered. However we are running into a problem where by if a user enters 200 lines of data, then deletes the last 25 lines, it is still...

I have a list of values in cells A1:A10. I want to create a macro so that cell B1 will first contain the first value in the list, then the second value replace it, then the third, and so on. Once the entire list is run through, it should loop back to the first value again. The same...

I have two sheets on the first sheet, Column A have the project name, I have Columns K, L, U where I have dates that change on a weekly basis. On Sheet two I have same thing starting with A27, I have the same project names, however on F27, G27 and H27 where I manually enter the historical...

I have two sheets, sheet1 and sheet2. On Sheet1, Column A have the project names and columns K, L and U have dates that are updated on a weekly basis and just consist of dates. K column dates are entered manually, L column have conditional formula basically adds x amount of days depending on the...

It seems to be a huge challenge for Excel VBA to format inconsistent text strings and so I am looking for a solution to format the following table: The table may contain hundreads of rows that have to be manually checked and so it is important to make it as readable as possible...

Hi All I have a problem with my code. I need to call on a .csv file, format it, select a specific dynamic range and paste it in the sheet the macro was called from. I managed most of the above, however, i can't get it back to the sheet the macro was called from. I have tried multiple options...

Hello All, Kindly help me for the below query which I need in the way of Excel-VBA. Here column A - is the serial number and I need to sum the values of Column C (56+44.01+33.20 = 133.21) and provide the value in Column D in row 1. Likewise, it needs to sum automatically for the Serial numbers...

I have a program in which a label is scanned and that value goes into a cell, but for security reasons, it's necessary to check that the length of this is always the same (for example: 8, label=12345-78) the string has a "-" in it. What I want the program to do is that, when the scanned label...

Hi, I'm trying to Trim visible cells after a filter is applied. It all works except for the result. Current Cell Value: "11 05 18 09:06:50: closed by linker #MIT # Updates were made well before SLA expired" Result Required Cell Value: "#MIT # Updates were made well before SLA expired"...

Hi, I need to select non-contiguous cells in a sheet and paste them to specific columns on the next blank row of another sheet. The code below can copy non-contiguous cells and paste to specific cells on the required sheet, but I cannot adapt to get it to copy to the next blank row. Sub...

Hope everybody is fine. I am stuck with a problem. what i am trying to do is subtract dates of column C from column AQ dates. the logic is if aq - c <= 20 then copy entire row to sheet1 else copy entire row to sheet2. column c contains empty cells it should automatically go to sheet 2 right...

I am apologizing in advance for my lack of in depth knowledge of macros and VBA as I am new to this. I am trying to add a command button on one sheet to take the data from multiple cell ranges and copy the data over to another sheet in one horizontal row. The data must be copied to the next...

Hi guys, I'm very new in this excel VBA. I have a problem with this table. see the picture This is sheet1 = all the data will be here. this is sheet2: only the selected element will show. the problem is, i don't know how to link/get only the selected value data to show in sheet2. I tried...

I'm trying to create a macro that will create appointments based on task from column B. For some reason, my code to create appointments is creating each item in the subfolder twice. Also, I'm trying to get the appointment date to be column F -30 days. Ultimately I would like to have this macro...

I'm trying to create a Macro to create Outlook appointments based on words in Column B. For some reason, my code to create appointments is creating each item in the subfolder twice. Also, I'm trying to get the appointment date to be column F -30 days. I tried <code style="margin: 0px; padding...

Now, I've never been accused of being the smartest guy in the room, so I apologize if this is a simple and easy solution, but here goes. Currently, we have a template that allows users to operate within a batch of specified sheets, with a pre-generated number of line items that they can add or...

Hi, I'm new to the forum and I would like to ask a question regarding a problem that I'm having with a userform. I have used this page as a way to learn more of excel and solve past doubts. What I'm doing is a userform where I want to ask the number of failures using a textbox, and then each...

Hi everyone, so I have here a code that omits special characters and converts phone letters into numbers. Sub Xabier() Dim myLen As Long Dim i As Long Dim myNum As String Dim newNum Dim ws As Worksheet: Set ws = Sheets("Sheet1") Dim rng As Range Dim cell As Range Set rng = Selection For Each...

Hi everyone! I'm currently creating a VBA that formats phone number. All numbers must follow a standard format. The scenario goes like this: In the user's selection, or highlighted part/selected part, all phone number formats will be "three numbers" "-" "three numbers" "-" "four numbers"...