merge cells

  1. D

    VBA code to merge rows

    Hello, I am trying to merge cells in rows based on the value of the cell in Column A of my spreadsheet (containing Document Type) through the continuous rows containing no Document Type in Column A [see below BEFORE and AFTER examples below]. This needs to loop through the entire spreadsheet...
  2. D

    vba to merge cells

    Hey guys, im looking for a vba to merge the current cell with all the blank cells below it. I'm automating a report, which turns into a pivot table, and then i need that pivot table in text format for something else. I was thinking of doing something like this and merge cells while recording...
  3. P

    Macro to merge columns with same value, with multiple rows.

    I have seem many VBA solution to merging cells in rows based on similar values, but I need to achieve this for columns (without any error messages), ie. merging columns within one row and then repeating down all rows. The range where data will merge is C3:AC176 (although if this could change...
  4. E

    Select a range of cells with the cursor then have those cells merge

    I'm looking for a vba solution. The reason I need to merge cells is to give me a final picture of what an end product would look like without manually selecting a range, pressing merge and center and then selecting another range etc... Is this possible? Thank you.
  5. C

    Combining every 4 cells into 1 without losing data

    Hello, I have a column with hundreds of cells, and I want to combine every four cells into a single cell, without losing data. Also, there should be a space between each string that is combined. So: Hi there how ru I am OK thanks That is great bye I want to combine so that I get three cells...
  6. H

    Merging cells on value based

    can anyone help me on following problem, i highlighted rows with conditional formatting, any row with date on sunday is highlighted, i want excel to merge cells C,D & E on sunday,plus show "Sunday" in highlighted cells as well. Please help.
  7. D

    Count the number of merged cells

    So I am trying to create a macro to count the number of tasks that are completed in a schedule. The schedule is for each day and it runs from 1am to the following midnight. The tasks are inputted as merged cells between the time the task is to take place. So what I need the macro to do is count...
  8. R

    Concatenate 2 columns to 1 in a loop across excel spreadsheet

    Hi! How do I concatenate ​2 columns to 1 - recurrently - till the last blank column? For example, see below the data. How do I combine Columns A and B to a new column after F (i.e., G), Columns C and D to a new column after G, Columns E and F to a new column after H, and so on? I have a...
  9. J

    Merge Cells VBA Run Time Error 1004

    Hello, I'm having a small problem with part of a code - and just dont know why it isn't working when using Private Sub Workbook_Open() whereas it works when using commandbutton()! Private Sub Execute() 'Clear All Previous Data With Sheets("Summary").Range("A3:K310") .Interior.ColorIndex =...
  10. C

    Merge Range of Cells

    Hi, I have been trying to merge a range of cells. I have tryed with .Merge & .MergeCells and it keeps telling me there is an error LastRow = Cells(Rows.Count, "D").End(xlUp).Row If LastRow > 2 Then Range(Cells(2, 2), Cells(LastRow, 2)).MergeCells = True Range(Cells(2, 3)...
  11. A

    Merge cells with same number within specific column range.

    Hi Wizards, Please can you help I am using this formula but I need the cells that have the same value between E17 and E758 merged not the whole column. Sub mergethem() Dim x As Long Application.DisplayAlerts = False For x = Range("E" & Rows.Count).End(xlUp).Row To 1 Step -1 If Range("E" & x) =...
  12. F

    Help with insert row and merge cells code

    Hello mrexcel Community :) I have a problem with my VBA Code in Excel, I dont speak VBA or even english :laugh: The code I have tried to create is not doing what I want it to do. When I click on the Command Button than it does not create a new Row. The result of my tryings is this one...
  13. N

    Merge multiple groups of adjacent cells, which are separated by a blank cell, into respective single cells.

    Dear fine people of Mr. Excel, I am not sure if this has a possible solution, but here is my problem... I have a pdf with a large list of hyperlinks which have a text description attached to them. I tried many different ways of copy and paste to get them formatted correctly in excel to...
  14. B

    Merge a number of cells based on a numeric value in 3rd cell

    Hi there, I'm trying something new to me in Excel using VBA: The base of data is a table with a fixed number of market segments. For each segment there is the same list of competitors (text values). The length of the list may vary as it is created by another macro. Associated to each...
  15. D

    merge cells in the Excel table

    Why does MS OFFICE (2007) allow for the same type of tables in Word that is in Excel to be able to merge cells, but not in Excel? You would think this would be a feature that would be available in all MS OFFICE tables. Has someone figured out how to merge cells in the Excel table? Please...
  16. J

    Merge two duplicate address lines but keep other details - Online order processing.

    Good morning, I have a complicated problem I need to resolve in terms of online order processing. Please see the below image; As you can see from the above sheet we have orders and each line contains 1 item. However, you can see that lines 3004 & 3005 are the same order, but the customer...
  17. I

    Implement a macro (increase cell +1 by right click) for Merge Cells

    Hi, I'm new on this forum I've got a problem with a macro used for increasing cells by 1 with the right click of the mouse This is the macro: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) If Target.Cells.Count > 1 Then Exit Sub If Not...
  18. N

    Web Query/VB or Macro Help - Merge Every 3 Rows

    Hello! I've been working on this for what seems like days. Ultimately, I'm wanting to know how to quickly grab data from a link via Web Query, then edit that data with a script or macro. End goal is to identify fantasy football draft trends: Web Query: Completed Draft - Fantasy Football...
  19. K

    Need to Combine different cells into 1 column

    Hi, i have a sheet with data in columns from a to somewhere to z this varies... in every column, few cells will be highlighted to red for us to indicate those were out of stock and we need to remove those, i want to know how i can combine all the red cells from a to z column into 1 single...
  20. E

    Macro to merge all cells in a column that have the same value in another column

    I'm very new to writing macros. I'm not even sure how to start this one. I want to merge all cells in a column that have the same value (would be Bug ID below). I know how to do that. But I also want to merge all cells in Bug description that match that Bug ID. I want to leave the host...

Some videos you may like

This Week's Hot Topics

Top