vba & code

Hi there, I am trying to write a VBA code in order to automate a PP to automatically update textboxes with excel data. The current approach is: Set Excel File Path: It defines the path to the Excel workbook from which the data will be read. Open Excel Application: It creates a new instance of...

Hello! I'm new to VBA, this is honestly my first time playing around in it, and I need some assistance. I have a group of cells on my excel sheet that I want to have copied and pasted into the email body, but everything I try comes up with nothing. :( Could anyone help? I also really need my...

Starting at A17 on Sheet 1 I have a row of data that I need the data from columns A,B,C,D and G (Column B is a specific ship date) copied to one of the ranges in sheet 2 that contain the 4 quaters of the year. The date in coulmn B determines which range of the quartely ranges it goes into. On...

Date Type Stock Price Quantity Amount VBA Correct 04-01-2024 Bought MINM 3,960 10 39,60 04-01-2024 Sold MINM 3,900 10 39,00 -0,60 -0,60 04-01-2024 Bought MINM 4,060 10 40,60 - 04-01-2024 Bought MINM 3,760 10 37,60 - 04-01-2024 Sold MINM 4,130 20 82,60 7,40 4,40...

Hello, I'm relatively new to macros and I have been trying to write a macro that will enable me to format phone numbers into (XXX) XXX-XXXX regardless of the manner or format the original phone number is. What stumps me is when there is an area code in the original phone number i.e. +1 440 299...

Hi, I am interested in writing a macro using VBA to loop through the file names within a folder and delete all files that are not named a specific file name. In the example below, I would like the macro to delete all files that are not named "Prepaid Maintenance.xlsx". So far, the only way I've...

Hello I am new to here and new to VBA, I have tried to make my code using some knowledge and chatGPT, however I have managed to updated only one row and please help me with the following problem. Sub FindAndCopy() Dim searchValue As Variant Dim targetWorkbook As Workbook Dim...

Hello, I'm super duper new to VBA coding with literally 0 past experience past this project I've been assigned at work. I basically need a code where the macro searches column D for cells >1 and then inserts rows according to the value in the cell while subtracting 1. So if a value is 2, 1 row...

Hi! I found this VBA code that helps me hide/show a specific range when selecting one or the other cell. However I would like to use this multiple times on different cells. For instance when selecting B35 hide row 36:38 and when selecting D35 showing row 36:38. When selecting B39 hide row 40:42...

Hi everyone, I have a password protected spreadsheet that I can easily group and ungroup while it is protected. I am wanting to create a button to easily do a bulk group and ungroup while the sheet is protected. I am happy to have 2 buttons (1. Group, 2. Ungroup) instead of just 1. Is this...

Hi, This is my first thread, so if there is anything I am doing wrong please feel free to let me know. I have a really simple VBA code to be able to scan a code bar, check it with an inventory list and copy the information in a 3rd sheet to control sells. I am trying to implement a simple code...

Good morning, I am not sure if the title does the question justice. If Columns A,B,D,E,F,G and H match BUT column C does not match, I need a way to split the total hours(Column H) worked each day across each unique area as the count in each area/divided by the sum of the total count by...

Hey, im new to vba coding and im trying to create an automated macro that constantly checks two cell values for my worksheet . Basically i want it to check cell A12 and if its equal and or less than 250 to update Cell C12 with the number 250 I had tried to do it like this with what i learned...

Hi all, I'm chasing a VBA macro urgently but don't know how to go about it. Thanks in advance, please see below: There are 3 documents, I have links to them below: Doc_1: Loading Google Sheets Doc_2: Doc_2.xlsm Doc_3: Loading Google Sheets What I require is a VBA macro in "Doc_3" which when...

How do i retain it from changing my formulas into Values. The only value change should be (i, 14) or Column N Option Explicit Sub btnStk_Click() Dim rData As Range, arrData Dim i As Long Dim sName As Long Dim sNote As String Set rData =...

Hi All, I'm self taught and have some pretty big knowledge gaps. I'd like to compare the Column A in my "Master" worksheet with Column A in my "Compare" worksheet. If a number is unique to Column A in my "Compare" worksheet I'd like to extract the information from the row and enter it into my...

My VBA macro runs reports from Excel to generate a Word doc with upcoming deadlines/due dates. However, I can't figure out how to include a description of the upcoming deadlines/due dates when I run macros. Here are the columns that I need help with: COLUMN A = MATTER NAME COLUMN K = TASK...

In a userform, I will select one product (of 300+), and a image appear... and I have all pictures put in another userform and multipages (can't use a folder as this have to be shipped to and from different computers and people). In my userform I can make the correct path to the image visible...

Hi anyone, I would like to match this 2 table as shown: Using the reference list, match the master list and return Column D to Column G. However the placement of the return has to be of the same position as the master list. Condition 1: If the code number of the reference list (Column D)...

Hello my fellow Vba coders My worksheet contains a table where I want it filtered based on two separate dropdown list. The user will first filter cell B3 where the table filters the data accordingly, and then if they choose to, by selecting a value on cell B6, the table filters the information...