**[Solved] VBA to Stack The Data in Two Columns** *Summary*: I have 300+ rows of data in each of columns A and B and I would like to stack them, starting from row 3. As an example I would like this:
A ...

**Auto Highlight Selected Rows - VBA & Conditional Formatting** *Summary*: In a database with over 10000 rows it's hard to follow each row of data so I was wondering if there's a way to highlight them, but without "damaging" ...

**[Solved] VBA Loop Range and Create New Range Based on Condition** *Summary*: I have a range defined in an Input box (oldRange). I use the code below to try and extract cell values in column A if the condition in column B is met...

**[Solved] VBA to Create Array or Collection with Unique Values** *Summary*: This is related to https://www.computing.net/answers/o... When trying to clear Best Answer in the topic above, the message said to only clear if there...

**VBA to Check if Email Sent/Not Sent and Display Text+Date** *Summary*: I have a code to generate and display an email using some data in an excel sheet. The email is generated based on an initial range of cells, let's cal...

**[Solved] Extract Unique Values from Range Variable** *Summary*: I've been busting my head for hours now and I can't seem to find a code to work without having to use an actual cell range in the sheet. I've tried ar...

**[Solved] VBA to Insert LastRow into a Formula to count Unique Values** *Summary*: I am using VBA to insert a formula which will count the unique values in a previously selected column. The formula is inserted in a cell of my choosin...

**[Solved] Does anyone know where All Experts went?** *Summary*: All Experts was a great site and one of their Excel experts, Thomas Ogilvey, was incredible at vba and macros. I asked him so many questions and he w...

**[Solved] VBA to Move String in Cells from End to Beginning** *Summary*: Hello, I have some values that represent a decrease of inventory and when pasting them in excel they come in the following form: 50-
140-
etc. I made ...

**[Solved] VBA to Generate Multiple Shapes Based on Number in Cell** *Summary*: Hello, I made a macro to create rectangles based on cell values for a 2D excel simulation. The code below adds the shapes once per each line I have in...

**Using VBA/Macro for data entry** *Summary*: Hi there, hoping someone could help me out with this. I am currently working on a project that seeks to find out the most popular content posted on s...

**[Solved] Macro to display message box once for each cell** *Summary*: Hello, In an excel file with various columns, I have a formula somewhere in column V that calculates a percentage. If this percentage is over 3% (...

**[Solved] Macro to memorize dates in a column** *Summary*: Hello, Assuming I have an excel file in which I want to complete a year's deliveries that are made on a daily basis. I will take a simple example: - a...

**[Solved] Macro to insert a formula in a column** *Summary*: Hello, Me again. I've been struggling today trying to make a macro to insert an INDEX-MATCH formula in a column (since I can't seem to make it work ot...

**[Solved] Macro to remove some text with condition and add color shade** *Summary*: Hello, So I made a macro to format a table. I will post the macro below and there are comments that explain things. Here's how my table looks like: ht...

**[Solved] How to edit an excel email macro to send only 1 email?** *Summary*: Hello, I got a macro online for sending emails given a condition. It works great if you have 1-2 entries that require email sending based on the cond...

**[Solved] (Easy) Excel VBA Conditional copy paste components of a row** *Summary*: Hey there! I am looking for a way to automatically copy paste values from one sheet to another based on the contents of the column in the following wa...

**[Solved] VBA copy a coumn contains certain charactor** *Summary*: Hello there.. Can I use VBA to copy column A to column B or C as below? Basically if it contains T511 it will copy to column B and if it contains PILC...

**[Solved] Excel Macro to match set of values to another through edits** *Summary*: Hi folks! I've tried my hand with some macros and done OK but what I want to do here is beyond me and need your help! What I'd like to do is search th...

**[Solved] Insert rows based on column count** *Summary*: I have data that I would like to write vba code to reformat. Specifically, I need to copy and transpose column data into rows. However, I do not want ...

**[Solved] VBA Code for SavingAs excel sheet without Message box!** *Summary*: Hi, I am trying to saveAs a macro-enabled workbook to xlsx format. The problem is every time excel shows warning message when the macro button is clic...

**[Solved] Can you maintain blank rows with a vba auto filter?** *Summary*: I have a worksheet with data that is automatically filtered when a date is entered in cell I1 via a Worksheet_Change(ByVal Target As Range) macro. Row...

**VBA to AD - error after 1000 users** *Summary*: I am currently working on a project to query AD , I have a script that do that, but the script is failing after 1000 users , while the users I am quer...

**[Solved] How to add $ sign automatically in the formula in MS Excel** *Summary*: Hi, I have an excel worksheet containing column A to M with data from row 2 onwards. E.g. For row 2, value in M2=K2+L2 and row3, value in M3=$M$2 For...

**[Solved] Check & set the start date after another task end in excel** *Summary*: I have a schedule control Excel sheet, such as below Item Task Start End "predecessor task" 1 Gather requirement 2016/5/3 ...

**Copying data to another worksheet based on criteria. - VBA** *Summary*: Maybe I'm just over thinking this, but I couldn't find anything about it anywhere. What I'm trying to do is copy a range of cells from a table on one...

**[Solved] Vba CodeCopy certain value of cell from column** *Summary*: Hi I am having difficulty to right vba a code which is below there is a huge data set in column C:C of which i have to work with 165 values which come...

**[Solved] How to match value in separate sheets and copy/past the row?** *Summary*: Hello everybody, So basically the situation: In the sheet1 (master reports) column A i have code such as AAA-12122 and then all details in the other ...

**[Solved] VBA code to insert new row and copy from row above** *Summary*: Hi, I have 100 groups of data. Group1: 10 rows of data in row 2 to 11 from ColA to G. Cell A2 to G11 have been filled up. Group2: 25 rows of data in r...

**[Solved] VBA code to copy cells to X-number of rows lower for X-times** *Summary*: Hello all Can anyone help me with this Little VBA script: I need to be able to select a cell, then run the macro and that macro will then copy the cel...