merge cells

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

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

Hello everyone, I would like to combine the data of some 12 sheets into one sheet. All data of every column should be present in the final sheet (this can become some 40 - 50 columns). The data of the columns with similar names should be merged across all (duplicate header names) columns...

Hello there, We are doing a graduation project on an international airport, consist of scheduling flights on check-in counters automatically. long story short, we ended up with an excel sheet like this: Were y-axis are the check-in counters and x-axis is the timeline horizon (cell per...

Hi I have the below VBA but I dont want it to merge blank cells and would like to define the range eg I:AB Sub MergeSame()Application.DisplayAlerts = FalseSet Rng = ActiveSheet.UsedRangeFor r = 1 To Rng.Rows.Count rngini = 1 Count = 2 For c = 1 To Rng.Columns.Count If Cells(r, c) =...

Hi I am trying to merge cells with conditional formating. I am trying to represent below but its hard. hope you guys understand what I need. Ie: 1.I would like to merge From Jan1 to Jan 4 and write insde the merged cells "A" 2.Merge Jan 5th to Jan 9th and write inside the merged cells "B"...

HI I have two columns Req | Expiry Date yes 11/12/2010 yes 08/06/2012 yes 02/07/2017 how do i merge both columns into one.. not losing any data hence Req Expiry Date yes 11/12/2010 yes 08/06/2017 I am using excel 2007 PLS HELP - ITS FOR WORK!:eeek:

I want to merge column E data base on Column B like become this how to create this macro, thanks for hekp.

Hi there, I have many columns in my current spreadsheet but I have two columns that I want to split in to two project names. Currently I have one column with: Project A/Project B And the second column with the total cost of Project A AND Project B combined The thing is that I can easily just...

Hello everyone. I am trying to manipulate an excel document so that I can import it into a flashcard system. To that end, my cells have to fit a specific structure-- A= [word ;(semi-colon delimiter)] / B=[" definition "]. To be more concrete, I must have a word with a semi colon in one column...

I currently have my program selecting the other worksheet to merge the cells and I have Screen Updating turned off but I hope there is a better way. Application.ScreenUpdating = False ' Disable the screen updating ALWs.Select '...

I am new to Macros and am having a bit of a hard time with two issues. I am using Excel 2010 and am working on a spreadsheet. The first problem I am having is trying to write a Macro in VBA that will hide a particular row of cells given a criteria. Cell U3 is my reference and contains a...

Hi everyone, I have a limited understanding of VBA but IM learning as I go :) The following code adds a new row at a given point (Based on a fomula in a column returning "1") The code works well BUT I want to merge this new row from column A to coulmn M Im not sure how to do this, (I dont want...

Hello All - Excel 2010 issues. I need to combine multiple cells in Column B that represent one to three descriptive lines for the data in Column A. I would like the contents of the descriptive lines separated by a space, merged into the first cell and the duplicative rows deleted. Excel...

Hi, I would like to combine 2 or more cells with a break-point. For example if A1= Apple B1 = Boy C1= (Empty cell) D1= Dog I want the text to show in my new cell as Apple Boy Dog Any suggestions will be helpful! Thanks in advance. Sam

Good morning, I have an excel sheet with data in 4 columns, i am want to create a macro that delete the first column, i m using this code: Columns("A:A").Select Selection.Delete Shift:=xlToLeft there is some merged cell (A:D), so the macro select the 4 columns. I learned this code...

I want to split a cell into two columns - without adding a column (since I have other sensitive data that will not allow me to add a column). Is there any way to split a cell into two cells/columns? Thanks M

Morning - Getting a little frustrated and need some help. Running Excel 2007 and I am trying to merge data on a second worksheet based on entries on the current worksheet I am using through a function. I tried macro recorder to get the syntax, but when I paste in to my function and make some...

Hi there, I have two excel sheets; Test Sheet and Variable Sheet. I'm using an index match function so that it matches two values from Variable Sheet and matches it to Test Sheet, resulting in data from a certain cell in a column range. Now, the only variable data that will change is "A7"...

Hi all, I need to drag a formula e.g. =Database!A1 down across a set of merged rows. I wish the formula to automatically update by one row at a time as I drag it down e.g. A2, A3 etc but instead it naturally references the number of merged rows (10 in all) it has been dragged over. Is...