Combining 2-4 Name Lines Based On Column B

Jan 8, 2008

in column A i have account name but it can be up to 4 lines (rows)

in column B i have the fund name which goes with the first account name row

so...

View 9 Replies


ADVERTISEMENT

Combining 3 Lines Into 1 On Graph

May 12, 2007

I'm having trouble combining three lines into one. I'm trying to do a daily weight chart and the x-axis is days of month, and the y-axis is the weight. I have 3 rows for the weight (one red line for weight going up from previous day, one green if the weight goes down from previous day, and one yellow line for equal). I want to make the three into one showing the colors. Right now all they are are vertical lines and are not connected.

View 9 Replies View Related

Combining Two Lines Of Code

Jun 14, 2007

I have two lines of code which I want to consolidate into 1. for example

Sheets("Snapshot").Select
Range("A1").Select

I've tried combining but get errors.
can they be combined

View 3 Replies View Related

Combining Cells In Column Based On Matched Value In Another Column?

Apr 5, 2013

I have a problem which requires a vba routine that is currently outside of my level of expertise...

Here is an example of the data:

TESCO GARAGE 3729
59
REF 177 1092098207 BCC
59
CO-OP GROUP LTD
60

[Code]......

View 3 Replies View Related

Combining Same Accounts On Multi Lines Into One

Nov 13, 2006

I have a report that I ran that gives me all the customer we have. Unfortunately, my system gives me a separate line item for any thing that my be different within the account like the account has multiple services. I need a way through excel or vba to take these multiple rows of the same acct # and site # and combine it into one line. Each account and site could have multiple services so I would need each consecutive service to be moved to last empty cell of the first such account.

View 11 Replies View Related

Combining Values In Multiple Lines

Apr 15, 2008

I receive a monthly report containing a list of people, and how much is being paid for certain services. The company that sends me this list is preparing to adjust their rates and it will be retroactive back a few months.

The way they plan on doing it is by means of taking a credit back several months, then "re-paying" the correct rate. The main data will include the month for which the payment (or credit) is being made, the person's unique identifier, as well as the amount.

Here's a sample of what it would look like:

Name, ID, Month, Amount
John Doe, 123, 04012008, 25.00
John Doe, 123, 03012008, -20.00
John Doe, 123, 03012008, 25.00
John Doe, 123, 02012008, -20.00
John Doe, 123, 02012008, 25.00

So basically the above shows they paid $25.00 (correct rate) for April 08, then they took back $20.00 the prior two months (the old rate) and paid the correct rate right afterwards.

In what I need to do, this is going to be a lot of work. Is there a way to programatically merge the amounts given the member's unique ID as the "key field" as well as the same month? So it might look like the following:

Name, ID, Month, Amount
John Doe, 123, 04012008, 25.00
John Doe, 123, 03012008, 5.00
John Doe, 123, 02012008, 5.00

Just giving the sum of the amounts for a the given people in the same month?

I'm pretty good with VBA but this one is stumping me.

View 9 Replies View Related

Combining Cells In One Column Based On Another Column

Jul 18, 2014

I currently have a spreadsheet that has 4 columns. I want to review the information in column A and if it matches, I want to combine the cells in column D into one cell for the matches in column A. Here is an example of the information I have:

123456
ABC Company
901
0001

123456
ABC Company
901
0099

[Code] ....

So basically I want to review column A and any # in that column matches, I want to combine the cells from column D into one cell. So I would want the first sequence to catch that A1, A2, and A3 match... so then it would combine D1, D2, and D3 into one cell that would read "0001/0099/HRA1". Is this possible?

View 9 Replies View Related

Macro That Duplicates Lines Based On Value Of Column?

Aug 22, 2014

I need a macro that duplicates lines based on the value of a Column. So in Attached excel D1 is 10 - I need it to create 9 entries for that line, so there are 10 total duplicate lines.

I had a Macro that worked that is in the document, I even had everything set up the same, which it is not now, but could not get it to work.

A Macro or a Finished document is fine, Just need this to produce raffle tickets for the church

Raffle Tickets.xls

View 2 Replies View Related

For Each Unique Value In Col A+B, Removing Lines Based On Column C

Jan 21, 2010

For each unique value of Order Number [col A] + Line Number [col B], I need a program which will locate the first instance of Next Stat [col D] = 530 and the first instance of col D = 540, deleting the other lines. The output will have two lines remaining for each unique col A+B combination, one where col D = 530 and another = 540. The data will always be sorted in date/time order prior to running this program. The actual data set has a varying number of lines, usually 1000+.

View 4 Replies View Related

Combining Year From One Column With Date In Another Column

May 1, 2014

I am working on a spreadsheet to track membership data. In Col A, I have the year that the member started their membership. In Col B, I have the dd/mm/yy that their membership renews.

For instance:
ABC Company began membership in 2002 (Col A). The next billing cycle (membership renewal) is scheduled for 7/1/2014 (Col B).

Is there a formula to take the month and day from Col B and the year from Col A and combine them? For the example above, I want the result to read: 7/1/2002

View 2 Replies View Related

Combining Cell Values In Column Based On Other Cell Values?

Mar 2, 2012

it should compare and see if product, model for same id is the same but brand is different and the quantity of one or more of those brands=0 then the result (In column F)should combine the brands. check the attached image for more details.

View 5 Replies View Related

Inserting Lines Based On IF

Aug 13, 2008

I have an amount of data split into various fields. I need to do something similar to the following:

In each row I have three fields separated by columns: name, sector and specialty. There is only one name and one sector for each record, but possibly several specialties (of which there are fifteen types in total, so they do not appear in a consistent column. specialty 'i' could appear in columns 3, 4, 5 through to 17. ie, sample entries below:

sheet 1
a1 name a2 sector a3 specialty i a4 specialty iv
b2 name b2 sector b3 specialty ii b3 specialty iv b4 specialty x
c3 name c4 sector c5 specialty i c6 specialty ii

The thing is, for every specialty in a row, I need new records created, so the above would become:

sheet 2
a1 name a2 sector a3 specialty i
a1 name a2 sector a3 a4 specialty iv
b2 name b2 sector b3 specialty ii
b2 name b2 sector b3 specialty iv
b2 name b2 sector b4 specialty x
c3 name c4 sector c5 specialty i
c3 name c4 sector c6 specialty ii

View 9 Replies View Related

Combining Two Columns To 1 Column

Dec 12, 2007

see the picture below to get an idea of what i want to do.

http://aycu15.webshots.com/image/362...0389296_rs.jpg

View 9 Replies View Related

Create Sheets Based On Lines

Mar 25, 2014

result of command is like below:

Code:
Entity,DATE,A_C,A_N,A_T,A_C,N_C,PER
YYY,24/03/2014,222 , 0002,ALARM TEXT DIFFER IN TIMEFORMAT , 1, 1,3.03030303
YYY,24/03/2014,333 , 0001,SCRIPT FAILED , 31, 6,93.9393939
YYY,24/03/2014,111 , 0003,ALARMS NOT RECEIVED , 1, 1,3.03030303
Entity,Sub-E,DATE,A_C,A_N,A_T,A_C,N_C,PER
YYY,9999992867290,24/03/2014 ,333 , 0001,SCRIPT FAILED , 7, 1, 100
YYY,9999992813525,24/03/2014 ,333 , 0001,SCRIPT FAILED , 3, 1, 100

[code].....

Now I'm looking is when opened in Excel, it should create a two sheets excel file 1) with the First Section and the 2nd with second section . based on headers included in file.which then will be used for PivotCharts..in 2nd stage of automating..

View 3 Replies View Related

Combining Cells Based On Value Of Adjacent Cell.

Jan 11, 2009

I have been reading through trying to find a similar post but the nearest i could find was one dealing with numbers rather than text. This is how the workbook looks.
Column A contains a list of numbers based on vehicle types. Column B contains a list of vehicle names.

A B
1 Car,
1 Taxi,
2 Bus,
2 Lorry,
3 Skateboard,
3 Bike,
1 Motorcycle,


What I am looking for is the best way to combine the text from column B depending on the value of column a. the finished results would then end up as: "Car,Taxi,Motorcycle,", or "Bus,Lorry," etc. This is just a simple list.. The one I am working with has around 2500 entries. I have been trying to do this using the CONCATENATE function and IF statement but it's just not working..... My head is ready to explode

View 2 Replies View Related

Combining Row Results Based On Specific Criteria

Jun 20, 2007

If I have the following table:

Name ProductSize QuantityPrice per unit
AX35510
AX451015
AX551210
BX601010
AX35510

I now want a resulting table that will combine all rows where name, produc, size and price are identical and have one row with the same data apart from the quantity that will have been added - so for the table above the resulting table will be:

Name ProductSize QuantityPrice per unit
AX351010
AX451015
AX551210
BX601010

View 9 Replies View Related

Trying To Lose All Lines With 0 In Column

Oct 22, 2008

I have to export some very large stock files into excel, which produces a stock list. However, the list is massively clogged by lines where there is zero stock. What I want to do is tell excel to remove all lines where a zero is found in column g (bearing in mind, there are breaks in the exported report where there is no data at all in some rows).

View 9 Replies View Related

Combining Numbers In A Column Into One Cell

Jan 14, 2014

Say I have a column of numbers. I'd like to be able to string them together in the following format: number1|number2|number3....

connect.xlsx

View 3 Replies View Related

Combining Column Information With A Formula

Apr 24, 2007

I need help with a formula so that I can create a single chart or (more likely) multiple charts for each of the choices in column C.

Attached is a sample of my spreadsheet.
I want to be able to break out each of the "Br#"(A) associated with the "BUM"(C) and graph each of the choices in column D (Run Time).

I am sure I can create the chart I need once I get the formula created to pull the data I am trying to combine. I hope that I have explained this well enough.

View 9 Replies View Related

Combining Some Of Rows Values Based On Multiple Criteria (2)

Apr 18, 2014

I have a table based on transport numbers who sometimes have doubles. Example:

Number Postcode Value1 Value 2...
106200 8500 10
106200 8500 5
106200 8600 6
106201 5500 4
106202 4000 1
106202 4000 1

So it works as following:

A transportnumber can have multiple instances of itself, such as 106200. This transport number can also have multiple instances where the postcode is the same. These are the rows i want to combine

So shortly:
Transportnumber double/triple...+ Postcode double/triple...= combine these rows.

if only transport number is double, or only postcode, then dont combine. I want it to combine 2 columns of values, one will b the kgs, other one a price.

So example of end result for 106200 would be
106200 8500 value+value (these 2 rows matched so it combined the 2 values i want it to)
106200 8600 value ( this was unique so it stays unique)

View 4 Replies View Related

Summary Page Of Lines With X Value In Y Column

Apr 7, 2009

I'm trying to make a task tracking spreadsheet. Each part (or project) that I'm working on has it's own sheet. On those sheets, in a specified column (let's say column A for now) I would like to add a tag or date that I can use to create a summary sheet. The summary sheet would have a macro that looks through each sheet in the file and if the value of the tag matches a specified value, the summary sheet would be populated with everything in each row that has that value for the tag.

View 4 Replies View Related

Combining Column Data When There Are Duplicate Row Headers?

Apr 10, 2014

I currently have a worksheet filled with data from other worksheets. I want to combine data from different columns when they share an identical row header and don't know how. For example:

1b--
1--c
1-d-
2-x-
2y--
2--z

Would go to:

1bdc
2yxz

Another specific issue is that some row headers are bold and need to be considered a separate header from the non-bold alternative.

View 4 Replies View Related

Shorter Macro To Move All Lines Based On Cell Value

Jun 9, 2014

Basically I want to copy and paste all data in a row if the value in a cell is equal to something

I am currently using the below formula

The Value in red = Set tgt = ThisWorkbook.Sheets(Criterion.Offset(, 1).Value 'Pick the cell next to the cell containing the criterion).

But my issue is now that i will need this to work based on 37 values and having this macro 37 times with the value changed and 37 buttons will be difficult.

So I am looking for a way i can add multiple values each going to separate sheets.

View 14 Replies View Related

Combining Text From Rows Based Upon Current Month Dates

May 19, 2014

I have sheet1 where there is a data.

Column A has dates and column F, G, H have some text with ',' ( e.g. Paper, wall, taps...etc)

I want to now combine text values from Column F ( rows of current month only) and place them in sheet2 in one cell with ',' in between text and not showing same item twice.

Sample book attached ....

View 10 Replies View Related

Combining Sheets: Aggregate All Into One Column On The First Sheet, 250 Rows

Aug 5, 2009

I have a book with 250 worksheets, with one cell of data per sheet. It is the same cell in every sheet (C7). I need to somehow aggregate all of this into one column on the first sheet, 250 rows.

View 5 Replies View Related

Separating Categories Located In One Column Then Combining It In A New Table

Mar 20, 2009

im currently working on a project that needs to consolidate the data per given date. but the thing is, all of them are located into one column. i was able to separate each category into separate columns but now, i cannot align the data on a per date basis.

View 10 Replies View Related

Checking Multiple Column Data Across Two Worksheets And Combining Them Into One

Dec 2, 2008

what i want to do is 1 have a workbook with 3 worksheets. Sheet1 contains the columns:

Reference No. Line Item No. Amount Date
1 3 500 12/01
2 4 900 01/01
Sheet2:

Reference No. Line Item No. Quantity PersonInCharge
1 3 10 Kim
5 6 60 Noel

For sheet 3, what i want to happen is that when i run the VBA macro, it searches through both worksheets (Sheet1 and Sheet2), finding rows that have matching Reference No. AND Line Item No. and combine all of the columns (and values) for that particular row into another row in Sheet 3. So for the above data set, the resulting data in Sheet 3 would be:

Reference No. Line Item No. Amount Date Quanity PersonInCharge
1 3 500 12/01 10 Kim

As this is the only entry in both sheet1 and sheet2 where there is a matching reference and line item no.

View 9 Replies View Related

Copy Data On New Lines From A Source Sheet Based On Criteria

Oct 2, 2006

I have a source sheet which contains data. Within this data there is a column (column 3) called Name and I would like to take the data from this sheet and paste it onto a new sheet but in grouped format. So take all instances where it finds criteria 1, then 2 and so on and just paste it on a new line each time it finds a criteria. So far I have the following code to search

Sub loopy()
Dim rngTemp As Range ' the range variable declaration
Dim intCounter As Integer 'counter as integer
' the following loop goes through all the cells in column a up until the last used cell in the column
For Each rngTemp In Range("a1", Range("a" & Rows.Count).End(xlUp))
'increment the counter if the cell has value fridge
If rngTemp = "Fridge" Then intCounter = intCounter + 1
Next rngTemp
MsgBox "There were " & intCounter & " cells equal to Fridge"
End Sub

View 2 Replies View Related

Combining Multiple Cells Into One With Comma Separation Based On Item Number

May 14, 2014

I want to write a formula/script that searches file names in Column "A" for an item number located in Column "B", then combines all file names containing that item number into Column "C" with comma separations. Each item number will have a different number of file names associated with it (between 1 and 10 files), and there are about 2000 different item numbers being crossed with about 7000 file names.

Here is an example completed with a CONCATENATE formula:

File Name
59481A_1.jpg
59481A_2.jpg
59481A_3.jpg
59481A_4.jpg
59481A_5.jpg
59481A_6.jpg
Q110XL_1.jpg
Q110XL_2.jpg
C5710_1.jpg
C5710_2.jpg
C5710_3.jpg
C5710_4.jpg

Item Number
59481A
Q110XL
C5710

Final Image List
59481A_1.jpg,59481A_2.jpg,59481A_3.jpg,59481A_4.jpg
Q110XL_1.jpg,Q110XL_2.jpg
C5710_1.jpg,C5710_2.jpg,C5710_3.jpg,C5710_4.jpg

View 4 Replies View Related

Put In Trend Lines When Creating Stacked Column Chart?

Apr 3, 2012

Is it possible to put in Trend Lines when creating a stacked column chart?

I've tried in Excel 2003 and 2010 but it doesn't appear that it is possible.

View 3 Replies View Related







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