vba

Good morning, Im looking to find a way to center check boxes in the cell they are placed, presently i have a check box list and id like all the check boxes to be in the center of their respective cell, is there a way to do this either with or without VBA? My check boxes start in Column C, Cell...

Hi, I want to rename my Sheet1 to PythonAI and Sheet2 to WebDev Can you edit the code below for me to not have an error. Thanks! Private Sub Worksheet_Activate() Dim LR As Long LR = ActiveSheet.Cells(1, 1).CurrentRegion.Rows.Count Range("A2:C" & LR).Select Selection.AutoFilter...

Hi I have reached the edge of my knowledge and need some assistance. I have a sheet that tracks crops and input chemicals, I need to summaries this into a table so that I can budget the cost based on the month the item is consumed. In Sheet 1. Data The first few columns are for the row...

Hi everyone, I'm very new to VBA, so really hoping you guys can help with this. I have a very painful that I need to do every week and I am trying to automate it to some extent to try and save some time (and my sanity!). I get a file from HR with the email address, name, title, and email+name...

I am a beginner at VBA and I believe what I require is a VBA code to help me solve what I am trying to accomplish. I have a list of numbers, and 3 tabs of tables. If any of the list of numbers match the number in any of those tabs, it will return the "number" along with the "Description", qty...

Hi, i am relatively new to VBA and i have problem importing data from text file. As the text file is too big, i do not want copy all data over to excel. Is there a way for me to create a VBA that only copies out all the rows with the same product ID as value in Cell A1? Then copy these rows...

I'm having a bit of an issue with an Excel power query and VBA. In VBA: I create a new sheet in my workbook and name it. I get my data from a CSV file with the information I need into a power query in my workbook. I can see the query in the workbook and view the data, everything is there. It...

Hi there. I've used Power Query to export a series of emails from MS Outlook. The result includes a column of the email body. I used a simple find/replace operation (searching for "<*>") to strip out HTML tags. After doing so, I'm left with a series of line returns, one after the other...

Hi, My Excel file freezes,stop working and took a very long time (15 minutes) to finish when apply the formula in G3 to the last row then loop next column. CDEFGHIJKLMNOPQRSTU1Point...

How can I use R1C1 references instead of A1 references. This is an example of where both collides and A1 references is used instead: Evaluate("=C1") (I want to get the first column values).

Hello Everyone! I have two files named Purchase Requistion (PR) and Database (DB). PR is in the format of a form which they fill in order to raise a PR request. This file is then "Save As" with a different name so as not to disturb the native file "PR". DB is a table format, which takes the...

Hi All, I been given a folder with a list of PDFs and I need to extract certain fields out of it to an excel sheet. However, we are only capable of using Excel 2019, so Power Query was out of the window. I'm currently attempting VBA to solve this problem. However, I'm not well-versed at all...

I am currently creating a macro to improve a weekly file update process. I have to copy a specific range of data from one file (file name "Previous Weeks File") and paste it into my current week file - the new week's file name has date changes: "File Update - 03-17 (Weekly)". How can I copy the...

Hi all! I have a report that is generated weekly for example 2401, 2402, 2403 etc. Is there a way that i can access data of these workbook from a master sheet. I have a formula that basically concatenates to the sheet name eg P:\weekly exports\2404.xlsm Is there a formula or vba that lets me...

Hello, I’m trying to write a vba script to return all columns that match a list of numbers. Some numbers have multiple rows of data. I use the choosecols and filter function to return the data which works. Now I’m trying to write a VBA script that does the same thing. Problem now is that it’s...

Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...

Hello - newbie here. Using VBA, I need to cut the last 36 rows of data and paste them to a new sheet. The actual number of rows will vary each time we use the sheet. Any help would be greatly appreciated!

Morning I have a code that highlights rows when in column B the word red is inputted, however, I need the code to work when I press enter is that possible Sub HighlightRowsWithRedInColumnB() Dim ws As Worksheet Dim lastRow As Long Dim i As Long ' Set the active sheet...

Hi all! Knocking out a huge project for work and I'm looking for anything to save time. I have successfully imported ~100 workbooks into a single workbook as sheets, labeled "3" to "103". From each of those ~100 sheets I'd like to copy the data in cells A11:Ax, C11:Cx, E11:Ex, and I11:Ix (from...

Hi am am trying to see if there is vba code to refresh a query that is a "Connection Only" i have the below code i am using but i am not seeing the query refresh when i go step by step in the code Sub RefreshSpecificQueries() Dim queryList As Variant Dim i As Integer Dim conn As...