merge cells

Hi to all, First time posting, I was no able to attach the MiniSheet, sorry for the looks! I'm still at basic level with Macros, but I am looking to simplify something that is taking me hours each week, to a simple clicks. I'm stuck with something super simple to do manually (merge cells), but...

Hi everyone ! I have some data in my "QSYS" sheet with 3 columns and I want to copy them to another "MasterListe" sheet under the last data. (Code should find first row that is empty and paste new data there) I need a VBA code for this purpose. I wrote this but it does not work. Dim lastrow As...

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...

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...

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...

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.

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...

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.

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...

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...

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 =...

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)...

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) =...

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...

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...

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...

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...

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...

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...

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...