merge cells

  1. J

    Help Merging Multiple Row Entries into 1 row with more columns

    I have a data file of donors. The file has a list of each donor and their giving history listed individually. I need it all on the same row. For example, if John Smith gave State University 6 donations over 10 years. John Smith ID# 12345 is listed 6 times, taking up 6 rows. I need it so that...
  2. J

    macro to merge a range of selected cells

    I need a macro to merge a range of selected cells in a column into one cell with a space between each value.
  3. T

    VBA - need autofit row height work around for merged cells

    Hi! Apparently I am trying the impossible... I have a spreadsheet that yes, has merged cells (for presentation reasons, I can't change that) and some places need text inserted. WHen I create the "final copy" I need to be sure all text entered can be viewed (because the sheet will then be...
  4. R

    Merging two columns; only overwriting blank cells

    I have a project I am working on for work. It involves 3 columns: Column A is the person's name, Column B is the computer name of the user submitted by the user, and Column C is the computer name of the user as provided from a report. Some users left Column B blank so we ran the report in Column...
  5. B

    Merge cells macro - loop through column

    Trying to write a basic macro here that will go through a column searching for blank cells, and merge them with the first activecell.end(xlUP). Here is an example of the data: Americas (blank) (blank) Americas (blank) (blank) (blank) (blank) Americas Americas Americas (blank) (blank) Here is...
  6. R

    Merge Cells Help!!!!!

    Hi I have a macro that runs and prepares a report but now I am required to give it a little make up. The problem with the make up is that I need to merge 2 cells from 2 columns range starts as of F8:G8 and should end when there is no more data on the rows below F8:G8. I've been trying to it...
  7. C

    Merge and Center Macro

    Hello, I am trying to get a macro to work but it fails (looks like it is running but does not merge) if there are any blank rows in the spreadsheet at the time the macro is executed. If there are no blank rows the macro executes correctly. I am not good at programming so I have turned to the...
  8. E

    Checking Named Range for Overlapping Merges Cells

    I'm looking to see if any one has any code snippets to flag a condition where a Named range contains cells that merge outside the range itself. For example, I could have a named range for B1:F1 which is 5 columns, but in this case, let's say cell F1 is merged with G1. So these count as one...
  9. J

    Question with tables

    Hi, I have a table listing projects a company has done at certain cities. Within one city there might have been several projects, so I have merged and center the cells under the city column for these projects into one. Like this: Chicago__| P1 _________| P2 _________| P3 Those...
  10. K

    How to concatenate text & number cells and turn them into date format

    Hi all, I have two columns. Column A contains years, '2010' for example. Column B contains months, 'Jan' or 'Mar' for example. Neither column is in date format. I want to merge them to 'Jan 2010'. Now that's easy enough, but I also want to make the cell a date and i find that much more tricky...
  11. S

    Merge cells / wrap text / based on duplicates

    Hi all, I'm new here, so if this is already posted in another tread, please forgive my newbidity for not finding it. My question is... ...is possible to merge certain cells in column B, make them wrap text every time a new cell is added to the merge, and base the merge on duplicate fields in...
  12. M

    Macro to clear content &

    Here below you see a copy out of a workschedule from my team. I need a macro (will create buttons for this) which deletes and merge some cells. In screenshot 2 you see how I would like to have the results. Also in screenshot 2 you see that in the shedule for Felix nothing changed (away...
  13. T

    cell formatted pop-up calendar

    When a user enters a cell (merged or not) that is formated with a date format, I want to pop up a button right next to the active date formatted cell? Then I want this button to open a date picker/pop-up calendar right next to the button. Then when the calendar closes... so does the button. I...
  14. P

    excel cell merge - lose formatting

    I have data that is formatted as text that looks like this (separated into four separate columns and cells): <TABLE style="WIDTH: 248pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=332 border=0 x:str><COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top