vba "&"

I have two spreadsheets (Sheet 1) and (Sheet 2) with similar data in different columns that I want to move to an existing spreadsheet(Sheet 3) in the workbook under the New columns for further analysis They have similar data and I need to create a VBA code that would consolidate all...

Hi, I have looked through various forums and tried my own code but to no avail. I have a sheet with data in 9 columns. The information i need exported is in column A. But i need to export column A (without the heading) based on Column C. But save the file name as column D and column C with...

Hello All! I have written the code below that does what I want it to do, but it is assigned to 1 ActiveX check box. I would like it to run anytime an ActiveX checkbox is used, but also only effect the one checkbox being activated. Any help or guidance is much appreciated!!! FYI there is over...

Is there a way to only copy certain columns from an auto filter? With the below example the active sheet has 8 columns of data G, L, P, R, S, T, W, AB (other columns have been hidden) When I copy the data, I don’t want to copy column W & AB so that only 6 columns of data will be moved to...

Hello Gurus, How can you delete/clear those cells that contains #VALUE! (note that it contains formula). So far I saw this code: = = = = Delete cell only If IsError(Range("C7")) Then Range("C7").Delete = = = = I have 10-15 tabs sheets and I need to run the macro like scan cells that...

Hi Gurus I found below code for changing the negative number in red. = = = = = Sub One_Way() Dim c As Range For Each c In Selection If c.Value < 0 Then c.Font.Color = vbRed Next c End Sub Source: VBA code to make negative numbers red and positive numbers black = = = = =...

Hi Gurus, I have some columns that I need to delete however, there are embedded picture image in cells. I tried using below code but the picture are still visible. = = = = Sub Delete() Worksheets("Sheet1").Activate Columns("C:C").Delete Columns("X:Z").Delete End Sub = = = = Is...

Hello dear friends, don't be bored I was looking for an article about creating a minimizer on the Excel user form, so that by clicking on it, the whole Excel will be minimized along with the active user form, and when I click on the minimized Excel icon in the taskbar, both Excel and the user...

Greetings and good time dear teachers: In an Excel file that has entered a series of specifications and also has a row, if we want to enter a specific and fixed cell, when we enter the row number, that desired row will be deleted and also pasted in another sheet, of course with VBA. What...

Hello! I have a data sheet that is purely Unique with no Duplicates named "Data Library" MNOP1K_IDAssessmentNameVignetteNameResponseType2k151371Acute Care AI Critical Thinking AssessmentAbdomen (acute)Action3k143531Acute Care AI Critical Thinking Assessment (Intermediate)Acute Asthma...

I have an excel VBA code to upload file to FTP server which works on windows, but I need it to work on Mac. I am using MS365. See the code below: Sub fileToFTP() Set FSO = CreateObject("scripting.filesystemobject") 'set the pathe and file name of the script to be run F =...

Creating new Post per developer request as requirements have changed. Old post: VBA - If unique value (ID) found in list, copy row to sheet2, if duplicate ID found, then paste first instance (based on date) to sheet 2, etc.. New Requirements: I have a Stock RSU source file that needs to be...

Hey everyone I have searched the whole internet for this seemingly very simple problem (its probably not going to be simple at all) So I have two workbooks: workbook X with cell A2 with a name And workbook Y with that same name (from A2 in X) as a worksheet name (multiple names/sheets get...

Hi, I'm trying out a new module where I'm trying to code an image as a global variable. I'm new to VBA so please forgive me if I'm doing some things wrong: Public Sub Variables() Global Astronaut As Shape 'Astronaut is the variable name (Image name) Global ws As Worksheet Set ws = ActiveSheet...

Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...

Hello, I'm trying to assign numbers to different Products using VBA. For example, if in "Products" column product "REG_AA" appears I want to assign it a number, if it doesn't appear I want to assign the next item in the list the number and go in series. If the product "REG_AA" didn't show up...

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...

Hi all, Does anyone know of a way to apply a style to cells based on their value/type? I have a table that I send out and each data type has a different style. I’m currently going through and applying the style to the cells as required. M wondering if there is a way to do this without me having...

Hi All, I would like to know how to achieve this condition programmatically. The main idea is to collect the same "attribute name" for each row for each grouping (column 2) Note: Grouping will be more than 1. like : Logi1, Logi2, Logi3, etc From this : To be like this (result): I had...