merge based on value

Hi everyone, I am a student who's new to Excel VBA and need some help with my code I have a column of values in range L4:L53: 4 2 2 2 2 3 5 .... and so on What I wish to do is merge the cells starting from X4 according to the values in column L E.g. The value in L4 is 4, cells X4:X7 should...

Hello. I need some help. I have this Excel workbook attached for inventory of medical supplies. Is there any formula alternative of consolidation that whenever the data in Sheet "Stock In" or "Stock out" would be entered, the duplicate data would be merged in another Sheet "Consolidated data'...

Hi, I need to merge 2 sheets (sheet1 & sheet2) in one new sheet (sheet3). In sheet 1 I have in the first column a unique ID and many columns (up to column CL), in sheet 2 I have in the first column the same ID (which appears several times) and few columns (up to column H). I have to merge these...

Find the * in a text string then merge the text across the columns. At the moment it seems to just merge a load of random cells Sub MergeCells() Dim myFirstRow As Long Dim myLastRow As Long Dim myCriteriaColumn As Long Dim myFirstColumn As Long Dim myLastColumn As Long...

Hi I have a unique problem. I have multiple csv files and I need that the date value (ddmmyyyy format) mentioned in B3 column to be printed from D5 onwards in D column across all cell where a value is mentioned in C column. I shall merge all these csv files into one xlsx file through VB code and...

Hi there :) I am new with VBA and I am trying to develop an excel macro for this topic, but I haven´t been able to find something that would meet my needs as a starting point, hence I am looking for some help to develop an excel macro that will merge rows, below and above an specific cell value...

Hi everyone, I have a dataset in which the top row gives me the days of the year and the cells below contain a formula giving me the name of a promo that covers a certain amount of days. The result is a dataset in which every row has a certain amount of contigous cells containing the same...

<tbody> A B C D E 1 Work Center Part Number Description Qty Good Qty Scrap 2 3 1234 4 Part A DescriptA 20 2 5 Part B DescriptB 5 1 6 5678 7 Part C DescriptC 56 4 8 Part D DescriptD 45 2 9 Part E DescriptE 90 0 10 9012 11 Part F DescriptF 12 2...

Hello, I have a workbook that contains classes a person must take based on their roles in a system (job duties). Because each roles requires certain classes and all of the roles have repeated classes, I would like to combine the rows based on the user while keeping all unique values and keeping...

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px;"> 0down votefavorite I want a macro that can first identify top 3 value and merge these values together, and then...

I'm trying to create a code that will make a selection of cells in a row automatically merge when a value in column A appears. If the value "Group 1" or "Group 2" appears in cell A2, the range A2:N2 should merge. I'd need to use this code in other rows of the spreadsheet too if possible, and...

Hi, I am trying to merge the cells in a column (column B) based on a condition in another column (Column C). In Column C, I have a list that starts at 1 and goes to a maximum of 10. However, it may stop at any number before 10 and restart. For Example: B C 1 2...

Hi all, I'm trying to merge cells based on a certain cell values. For instance, if column A was my helper and B-F represented the weekdays M-F, if the value in A was MT-WTHF I'd like to merge cells BC and DEF. Thanks for any help you can provide!

I'm wondering if there's a way of merging cells based on another cell's value. If Cell S12 = 17 then I want cells D12 to R12 to merge and to display a message ("Nothing Selected") Otherwise I have formulas and conditional formatting in them. Is there a way of doing this?

hi, i have a spreadsheet of staff training needs with over 145 courses.. some of these columns (of the name of the course) have the same heading, so some of the staff data is in the former and some in the latter - but its not duplicated... I just want to merge the two columns with same headers...

I have one document that has 10-12 sheets, each sheet contains data that I need to pull to a "master" sheet and cannot figure out how to do it. I would like it set up to do it automatically when I enter the raw data. This is mostly text or combinations of numbers and text and none of it is...

Hi Team, Looking for one function or macro in order to identify the blank cell (in sl.no column) if yes then it should merge the two given cells. I have data which is extract from PDF and in A1 column I have serial number the challenge here some cells divided in two different cells (down...

Hi All, I'm working on a bit of a mammoth task and I need to figure out what's the most organised way to display all the data on a master spreadsheet. I have about 8-10 spreadsheets that contain first names & surnames and the persons User ID for a specific location. Each spreadsheet has...

Hi, I am new at this and I am trying to figure out how to merge data from many excel 2007 workbooks (Win 7), in one folder, into one worksheet. Each workbook has 3 worksheets, all worksheets are protected by password (all have same password) all I need is the data from the first worksheet. The...