Merge Two Cells Based On Criteria

Dec 19, 2007

The begining portion of this works fine, I have it moveing data from one column to another, but I then need it to combine two rows (BW and P) and then place that into column (O)...

View 3 Replies


ADVERTISEMENT

To Merge Variable Number Of Cells Into One Single Cell Based On Criteria

Sep 19, 2009

Heres an example of my data:

A B
1110AAAAAAA
2220BBBBBBBB
3330CCCCCCCC
4330DDDDDDD
5330EEEEEEEEE
6440FFFFFFFFF
7440GGGGGGG
8550HHHHHHH

I need your help to figure out how to merge the above data to look like this in new blank worksheet using a VBA macro:

A B
1110AAAAAAA
2220BBBBBBBB
3330CCCCCCCC
DDDDDDD
EEEEEEEE
4440FFFFFFFFF
GGGGGGG
5550HHHHHHH

View 10 Replies View Related

Merge Adjacent Cells With Criteria

Aug 1, 2012

I need a code or macro which, when applied to a selected column, will merge a range of cells in that column into one cell. The criteria is to merge all cells into one cell that fall directly under the cell which contains "Items - total..." and that lines are separated by a line break (alt+enter).

Here's an example of what the column contains:

Before code:

A1: Items - total: 2
A2: four-legged
A3: cat
A4: two-legged
A5: chicken
A6: Items - total: 1
A7: four-legged
A8: dog
A9: Items - total: 3
A10: four-legged
A11: pig
A12: two-legged
A13: eagle
A14: marine animal
A15: shark

After code:

A1: Items - total: 2
four-legged
cat
two-legged
chicken

[Code] .......

View 1 Replies View Related

Merge Data From Sheet2 To Sheet1 Based On Required Criteria

May 1, 2014

I need to merge data from sheet 2 to data on sheet1.

Sheet 1 data is in the format given below with start date in G column and campaign ID in column H.

Start Date
Campaign ID

17-May-14
3834177

[Code].....

I need to look up Campaign ID of sheet 1 in sheet 2 and add all insertions and platform for that campaign to next columns i.e. I and J in sheet 1. For ex Campign ID 3834177 of sheet 1 has 5 insertions corresponding to it in sheet 2 hence the insertions and their Platform would transfer to sheet 1. Since Campign ID 3834177 is only in 2 rows on sheet 1, 3 more rows would need to be inserted in sheet 1 to accommodate 5 items and it would look like.

Start Date
Campaign ID
Insertion ID
Platform

[Code].....

View 1 Replies View Related

VB Macro For Variable Cell Merge Into HTML Code Based On Criteria

Oct 7, 2009

Does anyone have a VB macro that will copy information from a cell (this will be variable based on criteria) and paste it into the middle of another cell that contains HTML code?

The criteria for the copy/insert/paste is that the information in the cell that is to be copy/inserted must match up with the correct number (part number).

I hope this makes sense. I have attached an example spreadsheet. (Pictures are worth 1000 words. ) Hope someone can help. I checked this site and couldn't find anything that was solved that matched the specifics.

View 6 Replies View Related

Merge Cells Based On Used Cells In Column 5

Jan 7, 2014

I have data written in Cells B5, C5, D5 etc that changes as you add more column data

I am trying to figure out how to merge cells starting from Cell B3 based on used cells in row B5 to end of column.

View 6 Replies View Related

Merge Cells Based On Input From Another Sheet?

Jul 4, 2013

i am trying to merge cells based on the input from another sheet. these input will change from month to month and i need the sheet to cancel the merge and merge again based on the new input.

Example.xlsx the file showing what i need it to do.

View 8 Replies View Related

VBA To Merge Cells Based On Other Column Values?

Mar 19, 2014

Now I know that merging cells is usually not a good thing in VBA, but I'm working on a data report that just looks bad unless longer pieces of text can span several cells to minimize column width.

So here's the problem:

I have a column of 1's and 0's in columns E and F, and text in Column G. I want to merge the cells in columns G and H for that specific row if there is a 1 in either the E or F column for that specific row. And I need to do this for a long range...rows 7-5000. Any ways that VBA can do this?

View 4 Replies View Related

Excel VBA - Merge And Center Cells Based On Date Values In Row Below

May 22, 2014

I'm using the following code (found here: [URL]......) populate dates in row 13 for a dynamic Gantt Chart...

[Code] ....

It works perfectly to display daily dates in the mm/dd format. Now I want to have an overarching month/year displayed over the entire range for any particular month by merging and centering the cells above the month's dates the above code populates, and pull in the month/year formatted as mmm-yyyy. I've attached a mock up I did manually to convey the desired result.

MergePic.JPG‎

View 1 Replies View Related

Merge Cells: Select A Range Based On Two Variables Which Store The Column Numbers

Jul 19, 2009

I am trying to select a range based on two variables which store the column numbers. what I have is:

View 4 Replies View Related

Fill Cells Based On Corresponding Cells Matching 3 Criteria

Jul 1, 2008

I am working on a spreadsheet for a shoe company. I have separate columns for the size, model, color, and item number of a shoe. I get everything except for the item number from a written document; I then have to find the item number for the shoe from another excell document called the Master List.

I was hoping there would be a way to have Excell auto-fill the item number for me. For example, if a shoe is a Red, Athens (the shoe model),size 12, its item number (which can be a pain to find) listed in the row of the Master List is aaabbb. So I want to just enter in the size, color and model number, and have Excell find the item number for me, and fill it in.

I have enclosed an example. Sheet 1 is the sheet I would be working on. Sheet 2 is a portion of the Item master list, which is actually 50k lines.

View 8 Replies View Related

How To Copy Cells Based Upon Criteria

Dec 22, 2009

Here's what we need to do:

We are compiling one master spreedsheet from many smaller ones and I need to figure out how to copy them quickly and efficiently. For example:

Small Spreadsheet:

Column B is marked as P, M, C or S. This represents the type of the account.
Column C is the name of the account.

Master Spreadsheet:

We have a column for each account type (P,M,C,S)

Can we use a formula/macro to automatically copy columns B and C from the small sheet and organize them accordingly in the Master Spreadsheet?

For example:

Small spreadsheet:

P Account Name1
M Account Name 2
M Account Name3
C Account Name4
M Account Name5

would appear in the Master Spreadsheet as:

P M C
Account Name1 Account Name2
Account Name1 Account Name3 Account Name4
Account Name1 Account Name5

View 10 Replies View Related

VBA To Fill In Cells Based On Criteria

Apr 4, 2009

I just stumbled onto this forum while Googling around, and it looks great. I'm pretty new to VBA coding so please bear with me. Effectively what I'm looking to do in this mock-up file, is anywhere the currency is "EUR" in column A, I'd like the relative cell in Column G to change to "INSERT TEXT", else I want it to untouched (i.e. to keep the comment it currently has).

View 6 Replies View Related

Copy Cells Based On Criteria

Jan 29, 2010

I have data like in excel, which I uploaded and I need "simple" thing, If in column G is text Australia then copy from D column each cell which has "AUS1*" + copy the same number cell from C column and copy it into cell A and B. I hope I wrote it understandable

View 2 Replies View Related

VBA Copy Row Based Upon 2 Cells With 3 Criteria

Aug 29, 2012

I'm not sure why this doesn't work on the dummy data?

Problems:It doesn't recognize the September 2011 datesIt is supposed to pull dates between July and August (i.e. 2 dates) and pull everything except those dates.

The date strings have to be variable based since it can't be hard coded.

Code:
Sub copyrow()
Dim rc As Integer, row As Integer, i As Integer
Dim mm As String, fdt As String, pdt As String, mo As String, yr As String
Dim Date1 As String, Date2 As String
mm = Month(Date) - 1
mo = Format(Now(), "mm") 'ex. "08"
yr = Format(Now(), "yyyy")
Date1 = mm & "/01/" & yr
Date2 = mo & "/01/" & yr

[code].....

View 2 Replies View Related

Sum Range Of Cells Based On Criteria?

Sep 27, 2013

I have the following data

Country
Aug-13
Sep-13
Oct-13
Nov-13

UK
3
5
3
2

USA
10
14
16
13

France
1
5
7
9

What I would like to do is sum a specific range of this data based on three criteria. Each criteria is in its own cell.

- Start Date
- End Date
- Country

So if I wanted to sum from 'Sep-13' to 'Nov-13' for 'USA', the formula would give me the answer 43.

View 4 Replies View Related

Sum Cells Based On Row And Column Criteria

Apr 30, 2014

I am really struggling to summarise weekly budget data into period budget data by subcategory.

I have column headings A3 being Subcategory B3 being GL Code & C3 being GL Name - where column B & C are distinct values but column A are not. And then in D2 I have the period no e.g. P01, with the Week no in D3. I want to sum all cells that are in a particular subcategory and period - the data set is broken down by weeks.

View 4 Replies View Related

Locking Cells Based On Criteria

Jun 28, 2006

I have a query in relation to locking cells to disallow editing based on a dynamic range. The VBA code I have thus far is this :

Sub PasteForecastWO()
rowarr = Array(10, 26, 28, 69, 72, 79, 81, 87, 89, 104, 106, 114, 116, 122)
For Each ce In Range("S8:AD8")
If ce = "ACTUAL" Then
For i = LBound(rowarr) To UBound(rowarr) Step 2
Range(Cells(rowarr(i), ce.Column), Cells(rowarr(i + 1), ce.Column)).Value = Range(Cells(rowarr(i), ce.Column), Cells(rowarr(i + 1), ce.Column)).Value
Next i
End If
Next ce
End Sub

What I would like to do is lock the range that applies as the variable "ACTUAL" moves or changes along the range S8:AD8. I have attached the relevant sheet so that you may get a clearer picture.

View 7 Replies View Related

Mandatory Cells Based On Criteria

Dec 17, 2007

I need a macro that will check that the cells B1,C1,D1,E1 and one of the cells F1,G1,H1,I1 are filed out upon entry in A1.

If Not IsEmpty(.Range("A1")) Then
If WorksheetFunction. CountA(.Range("B1,C1,D1,E1")) <> 4 Then
MsgBox "All cells in row 1 are not filled out"
Application.Goto .Range("A1:I1")
Exit Sub

But how do I get it to also check that either F1 or G1 or H1 or I1 is also filled out. If possible I also would like it to beimpossible to add text in more then one of the cells F1:I1. Summary, upon entry in A1 I want cells B1:E1 plus one of the cells in F1:I1 to be mandatory, so in total there will be 5 mandaory cells.

View 2 Replies View Related

Delete Certain Cells Within Row Or Column Based On Criteria?

Nov 7, 2013

What i really need it to do is if each row in column H = "Cleared" then to only clear columns A, C to H. Theres a formula in B that needs to be left... any ideas?

Also i need this to work on all atbs as the commandbutton will on a master tab

VB:
Private Sub CommandButton1_Click()
With ActiveSheet
.AutoFilterMode = False

[Code]....

View 4 Replies View Related

Count Cells In Row Based On Criteria In Column & Row As Well

Mar 10, 2014

count cells row wise that meets criteria both in column & Row as well.

View 2 Replies View Related

Can A Formula Only Occupy Certain Cells Based On Criteria

Dec 8, 2009

Im currently using a formula in my report to track training completed by employees. The formula looks for the employee number in the report and the course name and marks Y to say if completed or N to say if not completed.

The level of the employees dictates what courses they need to complete i.e if its a store manager they need to complete all courses where as a bronze employee only needs to complete the first three courses.

At the moment i drag the formula up to the course they need to complete. I would like it if i could add something to the existing formula that looks at their level and then automatically only populates the formula up to the courses they are required to do.

Its very hard to explain so i have added an example:

View 8 Replies View Related

Open File Based Cells Criteria?

Jun 29, 2014

How to open files based criteria in cells value?

[Code] .....

View 5 Replies View Related

VBA To Populate To Specific Cells Based On Criteria

Jul 6, 2014

I am looking for a VBA that could populate from column (A2:A5) to cells (B2:F5) as in the attached spreadsheet, based on the frequency, in a five year time-frame.

screen_print.JPG

[Code] .....

View 1 Replies View Related

Run / Loop Through Cells And Delete Based On Criteria

Mar 4, 2014

I am trying to run (or loop) through a column of cells, and if cell contains certain text (e.g. ALPHA, BRAVO, CHARLIE) and delete the row if found.

My macro as I run it:

Sub DATA_TEXT ()

'Number of cells to loop through (I am unsure how the .xlend works!)
For i = 1 to 2500

'If function defining the criteria.
If cells (1, i) = "ALPHA" OR "BRAVO" OR "CHARLIE" Then

[Code] .....

View 4 Replies View Related

Sumif Criteria Based On Combination Of 2 Cells

Sep 19, 2012

I have different products with different sizes becoming operational in various months & years. I need to sum those sizes that are operational in a given month/year. In the example below, I have

-product A with 100 unit size, operative since 2007/03
-product C with 200 unit size, operative since 2007/10

So in the table with months on left, and years on top,
from 2007/01 to 2007/02, value must be 0,
from 2007/03 to 2007/09, value must be 100,
from 2007/10 to 2008/06, value must be 100+200=300 and so on.

For this specific example, I tried the following:

Code:
E2 = D2&TEXT(C2,"00")
fill to E7
B11 = sumif(E2:E7,"

View 2 Replies View Related

Concatenate Cells Based On Dynamic Criteria

Jul 22, 2014

I am looking to write a formula that can concatenate cell A$1$ (absolute) & B1: B245 (dynamic)and then A$2$- B1:B245 and then so on.

So for example, I need to concatenate cell A$1$ & B1, and then A$1$ & B2, all the way up until B245, and then I need to restart the sequence with A2 and B1.

Formula to preform this concatenation, or will this need to be done with VBA?

View 1 Replies View Related

Copy Cells Based On Criteria In Other Cell

Mar 20, 2009

I want to copy cells A&B where there is a value in G to a new workbook. I need to loop through the workbook as there are 25 sheets in the workbook, and there 8 workbooks to go through.

There are 31 rows on each sheet, and there are only a few values in column G on each sheet.

A is customer name, B is Account No, G is Insurance premium paid, columns C to F, and H to M have other accounting data in them.

The idea is to create a global list of all customers who have already paid their insurance premiums.

View 9 Replies View Related

Count Cells Based On Multiple OR Criteria

Jul 21, 2009

I need to have multiple ranges count based on several criteria. The hitch is that needs to count if one or more criteria is met not all. I tried using a COUNTIFS however that seems to evaluate based on AND not OR.

Is there a nested COUNTIFS or similar function that would work?

View 9 Replies View Related

Macro To Color Cells Based On Criteria

Jul 27, 2009

Column DColumn EColumn FTarget %DifferenceCash4%5.12%Large-Cap8.5%1.73%Commodities4%-1%

I need to color code Col F based on the following criteria:

If F2/E2>20%, then shade pink else no color. I only care about the absolute values. The 20% number can change depending on the category. So for commodities, the limitation is 30%. Like that I have a list of about 20 asset classes, 14 of which have the 20% constraint, rest are either 25% or 30%. I would like the cell color to be updated each time I import a file. Also I have other conditional formatting on Col F (like red color if negative number) so I don't know if another conditional format will work on the same cells?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved