merge cells

Hi Friends, Could Anyone Help This Issue. I am having an Excel Spreadsheet which has the values as follows A1 = 1000 B1 = C1 = D1 = (B1, C1, D1 are Nil Values) I have Merged all these four Cells so that it displays only 1000 in the range A1:D1 But what is the problem now is If I am...

Hi guys, Looking for some help. I am looking to use the manually entered 'Start' and 'End Date' to merge cells over this period, add 'Description', then colour code based on category. How can i make this possible, usually quite competent, however, this has got me baffled! I have a...

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

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

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

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

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

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

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

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

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

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

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

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

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

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