vba & excel

I am trying to use a listbox on an excel worksheet. I have only worked with listbox's in a userform environment with advanced filters. I would like to perform the same type of action in a dashboard on an excel worksheet without calling a userform using an active x listbox. Is that even...

Hi I am trying to automate a workbook that uses just a few entered fields to populate the correct information and formulas in columns and cells in the table below based on 2 button clicks. User enters start and end date, and then time ranges for each day in the top of the worksheet. The Columns...

I have a dashboard with data slicers on a worksheet called "Charts" and then on another worksheet called "DT_Summary" that has 7 pivot tables running vertically in columns D150:E400. I also have a table in DT_Summary ranging from A1:B100 that has a static list of all of my Downtime reasons, and...

Hello, I year ago I asked this question and I got a great answer but now I need some help creating a conditional statement within the code: The code below will in its current state insert "x" amount of rows dependent on the specified "row interval." Sub InsertRowsAtIntervals() 'Updateby...

I have: 1. A sheet with a list, including index #, name, location, and "Create Template" hyperlink; and 2. A template sheet within the same workbook, to be used for each entry on the list. My goal is to create a macro that, once the "Create Template" hyperlink is clicked, it: 1. Creates a...

Create A UI Design of two textbox and two button and one execute button to select a particular folder which consist of many files and consolidate the Data of all files in single file and save in out put Folder Open the consolidated file and Remove duplicates of those data and save it as final...

I need help changing a piece of code that @JoeMo came up with on this forum. Private Sub Worksheet_Activate() Dim wSheet As Worksheet Dim n As Integer Dim calcState As Long, scrUpdateState As Long calcState = Application.Calculation Application.Calculation = xlCalculationManual scrUpdateState...

I'm newbie to VBA and have limited knowledge in making complex formulas in spreadsheet so I'm having difficulty thinking of a better approach to achieve my desired results. I want each cell in multiple rows and columns to get a value of 1 or "" depending on the following logical test: If Name...

Hello. Sub RwData(rng As Range, col As Integer) Dim Dn As Range For Each Dn In rng With Application Dn.Offset(, -5) = .Max(Dn.Resize(, .CountA(Dn.Resize(, col)))) 'column H or 8 - is minus 5 from 13 or column M Dn.Offset(, -3) = .Average(Dn.Resize(, .CountA(Dn.Resize(, col)))) 'this is...

Hello, If someone could help me, it can be vba or just formula in excel. My dilema is to make a scheduling calendar that tracks the frequency of lab test. For example, normally test should be done every three days, which will be recorded in the calendar. However, if for 20 days, the tests seems...

Hi all, Could really use a help with this. I have use a shared spreadsheet that I have to do some simple calculatios, searches, sumifs, etc. The example code is working fine to find the last row and column... and start the calculation but just cant get the autofill to work. What Im trying is...

Hi guys, Can you please help me with this issue? I have a list with fruits (I2:I13), and I want to create VBA form with one lable and one button, where on the lable it will be written the name of the fruit (first on the list), and by clicking on the button it should change the name of the...

I have script that will look that will search for specific text within a cell in a specified column. If found, it will change the interior color for the row of the table. If not found, the script will loop to the next cell in the column until the last column is reached. This script is working...

Good afternoon, I wonder if anybody could assist me with the VBA code. i am trying to archive row to be moved to another sheet based on the value of T2,T3, T4 & T5. i would like to move the complete row to another sheet called T2&T3 if value found in cell A and T4 to separate sheet called T4...

Hi Gurus, Good day! I was looking for some codes on how to create a prompt if the data is not the same. I saw this which is workable but I need to apply the condition that if the cell is blank, it should ignore it: ========================================================= "= Existing Code...

I couldn't solve the 91 error in this code : Sub textCheck() Dim IE As Object Dim doc As HTMLDocument Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.navigate "https://sanctionssearch.ofac.treas.gov/" Do While IE.Busy...

Hello guys! I'd like to count how many rows with contents. But I tried lots of methods, I got "the number of the bottom row". Ex. My data are like "A1,A3,A99", and I wanna get "3 rows", but turned into "99 rows" always.

I have the report in which I want to delete some cells to the left as shown in the excel file Original report Expected result Ordered by owner Order number Ordered by owner...

I need help with vba code, I need to move files that contain "CSC" in the file name to another folder, there .pdfs. The orginal folder will have pdfs names simlar to but not limited 123456_256_2022526 or CN_CSC 20220506 or CS_CSC 1234567890_222222 or C_CSC 23456158_222234. I only need to move...

Long story short. we have about 10 teams that were running a template that had macros embedded in the files. I'm trying to see if its possible... if i had a list of the 10 file locations, go down that list, open the file and then run said macros associated with each opened file. before I dig...