Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Combine Multiple Rows Into One Row


I have a 8500 row sheet with 40 series of data given for each "data set". This data is situated in four columns and ten rows, so that rows 1-10 contain one data set, rows 11-20 contain another data set, etc...

Does anyone have a simple VBE script that can grab this data and format it so that my data sets are arranged as 850 rows and 40 columns instead of the native 8500 rows and 4 columns?


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Combine Data From Multiple Rows
so basically, here's an example of what I have. The spaces in between represent different cells:

Name Corporation Type Group
Vicki SchweitzerAon ConsultingBusiness GroupCouncil 1
Vicki SchweitzerAon ConsultingBusiness GroupCouncil 2
Vicki SchweitzerAon ConsultingBusiness GroupCouncil 3

What I want to have is instead of having 3 rows in this instance, I want to have a macro that looks at rows and if it finds multiple rows with the exact same name, corporation, and type, it merges the rows to look like this:

Vicki SchweitzerAon ConsultingBusiness GroupCouncil 1, Council 2, Council 3

In some instances, I have 3 rows that might match, some its 2, some its 10, it varies.

View Replies!   View Related
Combine/merge Row Cells Text Between Blank Rows
I have a large list of text in one column which i need to combine between blank rows into one cell or a new column, the number of rows to be combined varies.

for example

aa
bb

ww
xx
zz

rr

gg
hh
ii
jj

would become

aa bb
ww xx zz
rr
gg hh ii jj

I have over 30000 lines so doing it by hand is not an option.

View Replies!   View Related
Combine Multiple Records Onto 1 Row Based On Unique Number In Column
I searched and searched and I can't find an easy way to do this without using Access which I am rubbish at. Is there an easy way to do the following in Excel.
I have several thousand records by row each with a unique numerical identifier. The unique identifier is the "Household". Within the household there are sub "Accounts". The sub accounts are truely unique. All the "Accounts" are in the same column.

What I am trying to do is combine the records into one row per "Household" with the accounts listed in successive columns. The maximum number of accounts there may be is 7 but it can be as few as 1. Example:

BEFORE
HH Acct
1 1234
1 2345
1 3456
1 4567
2 9876
2 8765
3 1113
4 5556
4 4447
4 3335

AFTER
HH Acct1 Acct2 Acct3 Acct4 Acct5 Acct6 Acct7
1 1234 2345 3456 4567
2 9876 8765 8765
3 1113
4 5556 4447 3335

View Replies!   View Related
Combine Workbooks With Multiple Sheets Into 1 Multiple Sheet Workbook
I have about 20 workbooks with different file names for different projects all saved in the same folder. Each workbook has about 10 worksheets and each worksheet is named in a similar fashion in each of the 20 workbooks (eg. revenue, cost, variance etc.). I want to pull out a worksheet named ' forecast' from each workbook into a master workbook so that the master workbook would contain the 20 forecast worksheets.

View Replies!   View Related
Multiple Rows To A Single Row
I have a long spreadsheet, that has a format something like this: ...

View Replies!   View Related
Single Row Into Multiple Rows
Is there a way convert single cell with wrap text into multiple cells with the number of resulting rows based on the number of lines in the original cell. Due to the restrictions of my overall printable "document", I must use multiple cells of the same height. Any change of row height would throw off the desired final result.

As an example, when I start with my original cell in text wrap and set column width I get something like the following in cell F2:

ASTM A743 UNS J93254
(SUPER AUSTENITIC)
(LONG LEAD TIME
MATERIAL)

This looks great, but it is all in one cell, and the four lines of wrapped text have obviously increased the row height which is bad.

I have tried using the LEFT and MID functions to force the text into different rows based on character length, but this is sort of messy since I am never sure what the input will be resulting in something like the following (this time in cells F2:F5) with spaces at the beginning of a line or breaks in the middle of words:

ASTM A743 UNS J93254
(SUPER AUSTENITIC)
(LONG LEAD TIME MATE
RIAL)

My ultimate goal would be to somehow format the original input data text so that regardless of the input, the text would be restricted to a certain column width, sending the remaining text to the next consecutive rows down, and maintain the integrity of the original. I can have as many intermediate cells, formatting as I go to get to this point.

Of course, I could manually enter the text in the different rows every time, but it would be nice to have a succession of formatted cells so that the desired end result would be automatic. Hopefully, the answer does not involve too much in the way of macro or any VBA code since I am a pitiful novice, and we are sort of under pressure to get this project under way.

View Replies!   View Related
Multiple Rows Into One Summary Row
I have a sheet that has a few companies but gets "duplicating" because they have different transaction dates of when amounts came in. How do I put that into one row?

Attatched is a sample xls file On sheet1 I have my current situation ans on Sheet2 I am showing what I want, I find it difficult to do it or maybe it is simple?

View Replies!   View Related
Copy Formulas From First Row To Multiple Rows With Some Changes
I have 100 excel file in a folder such as File1, File2, File3, File4 etc.There are some figures and reports on these files. format of all the excel files are same except values. And I have a master file.

As is:
On my Master file, I have n number of formulas in Row 10,which gets data from the above excel files.
eg. Master file Sheet1 Row 10,
I have formula like this from Column B
='[File1.xls]Sheet1'!$A$1 [File1.xls]Sheet1'!$D$1, ='[File 1.xls]Sheet1'!$A$1 [File 1.xls]Sheet1'!$M$1 etc.

In Row 11,

='[File2.xls]Sheet1'!$A$1 [File2.xls]Sheet1'!$D$1, ='[File2.xls]Sheet1'!$A$1 [File2.xls]Sheet1'!$M$1 etc.
If there are 1 or two files then I can type manually in each rows, But I have more than 100 files. So i need a macro which copies the formula from Row 10 to rest of the rows, If there are 100 files with different names in the folder, the formulas have to be copied to 100 rows in the master sheet.

if the file name changes on the formulas I will get the data correctly.

View Replies!   View Related
Macros To Move Multiple Rows To One Row.
This report spreadsheet is exported from SAP. Since SAP has a limit number of displaying the columns, there are 40 headings (= 40 columns) in the report has been broken down to 4 rows of headings.

How to use macros to move 3 those extra rows to one row and the number still matches each column? I also attatch the file for reference.

View Replies!   View Related
Match Multiple Fields In A Row Over Many Rows
I have 4 colums of customer input data, Length, Width, Height and Quantity. There are over 20 rows to accomodate multiple combinations. I have several other hidden pricing pages with all possible combinations including materials, pricing etc. Assuming I am on the frst pricing page and first combination I need a formula that will match the first 3 inputs per row and if true give me the 4rth input for the matching row.

Example:
Customer input-
row 1 = 8 - 12 - 4 - 15
row 2 = 4 - 4 - 2 - 25
etc.

Order Page-
Combination 1 = 4x4x2 quantity___ (input row 2 matches 4-4-2 give quantity 25)
Combination 2 = 4x8x2 quantity___ (no input row matches 4-8-2 give quantity 0)

Combination 36 = 8x12x4 quantity___ (input row 1 matches 8-12-4 give quantity 15)

View Replies!   View Related
Combine Multiple Sheets From Multiple Books Into One
I have 6 spreadsheets all within the same folder, these are pretty much identical (rows, colums, sheets within them) apart from the names of the files.

I then have a master spreadsheet within the same folder where I want to combine all the data, from all the sheets within each book (if that makes sense!) apart from the data on the last sheet within each book as this is the reference data, onto one sheet within this master file. If possible I only want to copy rows accross which have complete data too.

So: (names not correct)
From book1.xls copy all data on sheets (sheet1, sheet2 etc) except last sheet
From book2.xls copy all data on sheets (sheet1, sheet2 etc) except last sheet
combine onto masterfile.xls on sheet1.

I have searched on here and can only find how to do it with the first sheet in each workbook, not looping through all the sheets in each book. Please see below.

View Replies!   View Related
Combine Multiple Worksheets From Multiple Workbooks
I'm trying to combine data from several worksheets (one sheet per workbook) into a single, consolidated master worksheet for reporting purposes (filters and pivot tables). We do not need to keep formulas for the master worksheet, only values and formats. Individual worksheets are used by different users to capture case data in a Human Services field. Column headings are identical, but rows contain data on individual cases. I'm trying to find a relatively easy way to combine multiple worksheets into a single master. After I establish the worksheets and technique, it will be operated by extremely basic users so I've been reluctant to use extensive macros.

Because of complex reporting needs, the exact combination of worksheets being combined for reporting may vary. For example, one time I may combine Tom, Dick and Harry, another time Tom, Dick and Bob, and yet another time Tom, Dick, Bob and Harry. Obviously, one method is to cut and paste the rows into a single worksheet. Are there more elegant solutions that could easily be handled by very basic users? Worksheets are stored in a single folder along with a separate worksheet used for validation rules (as you can guess, this would ideally be a database application but for various economic and political reasons we are using Excel). One possibility, if straightforward, is to use Access to consolidate data then export it back to Excel for analysis. I've scoured the various threads but have not found a situation mirroring mine. The number of rows for each worksheet is generally less than one hundred, but there will be a few exceeding several hundred. Total numer of rows of the resultant master worksheet will not exceed 10,000.

View Replies!   View Related
Consolidate Multiple Rows Of Data Into Single Row
I imagine my goal could be achieved via some scripting code, but, alas, I don't do vbs. Here's the situation:
I have a spreadsheet generated by another office which lists individuals' names and information about participation in various programs. Each line lists name, address, program title and amount. The next line may be the same name, address with a different program and amount. Each person may have 4-5 entries. I want to make single entries for each individual, with colums showing the programs and amounts.
Current:
ID Name Address Program Amount
1 Bob home A 25
1 Bob home B 37
2 Dave home A 22
2 Dave home B 10
2 Dave home C 21

Need:
ID Name Address Program A Program B Program C
1 Bob home 25 37 0
2 Dave home 22 10 21

Hopefully this makes it a bit more clear. The only way I know how to accomplish this is the "old fashioned" long hand approach of cut & paste. There are several thousand individuals, with (currently) tens of thousands of rows.

View Replies!   View Related
Organize Data From Multiple Rows Into Single Row
I would like to automate, due to how long it would take to manually organize the data myself. I have all of the raw data needed organized into 3 columns. The problem is that some of the related data is divided up into multiple rows, based on ID number. What I would like to do is take the related CPT codes and respective descriptions, from the same ID number, and place them on the same row. I am going to include some pics and even a small chunk of the source data. Here is a pic of the raw data:

And here is the first 3 already done:

The number of CPT codes per ID number range from 2 - 5 I believe, maybe 6. Not sure if this has any bearing on how it is done.

View Replies!   View Related
Converting Multiple Records (rows) Into One Record (row) Using A Unique Identifier
I would like to combine values from multiple records into a single record using a unique identifier. In the example below 'ID' is the unique identifier.

For example:

View Replies!   View Related
Combine Rows Into One
I have data as follows -
OrderTDF
1gc3
1gc3
2du3
2du3
2gc3
3du3
3du3
3du3

and want to combine lines by order so that data now becomes this -
OrderTDF
1gc3gc3
2du3du3gc3
3du3du3du3


View Replies!   View Related
Macro To Combine Rows
I have a table which has employee names on the left handside. Next to them are contacts in a region.

View Replies!   View Related
Combine Number In One Row
I want to combine number in one row.

Column A
12
13
14
15

Need to be in column B. 12,13,14,15. I tried =A1&,&??

View Replies!   View Related
Combine Multiple If Statements With OR
=IF(VLOOKUP(B3,'Rep List'!$E$1:$I$10000,5,FALSE)=OR("BH","AC","#N/A",0),VLOOKUP(C3,'Rep List'!$A$1:$C$1000,3,FALSE),VLOOKUP(B3,'Rep List'!$E$1:$I$10000,5,FALSE))

I'm getting the "#value" error - the vlookups are working independently


View Replies!   View Related
Combine Multiple Like Sheets Into One
I have a worksheet that has about a dozen sheets that are all the same, just different data. Each sheet is like a checkbook register that has date, memo, amount.... each sheet is for a different account. I have a form that I enter the info into, it puts it into the right sheet and sorts that sheet. This part all works.

But now, I want to take all the info from the different sheets and combine it into one master register sorted by date. I won't make changes to info in this master register, it would just be for info, so it doesn't have to work backwards. I need this to be automated.

Obviously, it's easy to copy all of them to different areas in one sheet, but I want to have them all in the same columns, and that is what I can't figure out. My sub registers don't have the account name listed for each entry, as it isn't necessary as the registers are labeled. But, the entries in the master register would have to have them to figure out where they came from. I can solve this by adding it to the sub accounts and hiding it or something if that is the easiest way. I also need to make sure it doesn't remove duplicates.

View Replies!   View Related
Combine Multiple IF/AND/OR Statements
If my input page B13 is either New Lease In-House or New Lease w/Co-Borker andmy input page B43 is - then take cell D57 in my Analysis report, mulitply it by cell B32 from Input page and divide it by 2, otherwise, take cell D57 on the analysis report, mulitply it by B42 on Input page and divide it by 4. I think I have a mess up with my brackets. This is what I have: =IF((OR('Input Page'!B13="New Lease In-House",'Input Page'!B13="New Lease w/Co-Broker"))AND('Input Page'!B43="-",'Analysis Report'!D57*'Input Page'!B32/2,'Analysis Report'!D57*'Input Page'!B32/"4")

View Replies!   View Related
Combine Multiple If Formulas
i have 2 worksheet function IF statements that of course look for certain conditions, but in some instances i need to combine the IF statements in one cell, the 2 i need to combine are below:

=If(D3="S","Sick",If(D3="SW","Swapped",Sheet2!B3))

=If(Or(C1="Line On",G1="Line On"),Sheet2!B3,"")


so what i need is for the cell to show either Sick, Swapped or the contents of Sheet2!B3 however if both C1 and G1 show Line Off then cell must be blank, which is what i achieve with the second if statement.

View Replies!   View Related
Combine Multiple Worksheets
I need to transfer a lot of data from many worksheets into one worksheet. The columns are all uniform, but the rows are not. Id like some VBA code that would look at worksheet A(1) and copy the first entire row where column A is not blank and paste it to the first blank row in another worksheet titled A(Combined). The code would then copy the second blank row in A(1) and paste it into the next blank row of A(Combined). The code would continue until all rows with data in column A are transferred to A(Combined) and then proceed to worksheet A(2), etc. and do the same. See the attached workbook

View Replies!   View Related
Combine Data In Rows For Certain Fields Only
I need to combine data from multiple rows to single rows, for certain fields only. The database is large and can described as having an ID column, followed by columns 2 to n that do not need to be combined, followed by columns n+1 to N that do.

I've attached a sample dataset along with the desired outcome. For the purposes of illustration the sample uses n=3 and N=5 but the actual dataset has much larger dimensions.

View Replies!   View Related
Merger Or Combine Data In Rows
I am hoping to combine repeated data into single rows. The best way for me to explain is to attach a spreadsheet with an example of how the data is and how I would like it presented. The spreadsheet has comments to highlight this.

View Replies!   View Related
How To Combine The Data In A Row Into One Cell
I am trying to combine the data in a row into one single cell.

For example,

B2= A1 & A2 & A3 .... until the end of the values in column A

I need this to be a macro so that when I enter values into column A manually and press the macro button, it will combine them into cell B2.

View Replies!   View Related
Conditionally Combine Information In One Row
I'm building a complete part number reference for all service parts of copiers of a certain brand. Every row contains three columns; partnumber, description and machine type. Problem is, some parts are used in more than one machine. When the list is complete I want to do the next: If partnumber in (column A) is found in more than one row, I want to join the information of the other columns in two cells. (see attached example).

View Replies!   View Related
Combine Multiple Vlookups In One Formula
I am using this formula
=IF(SEARCH("pipe",A2),VLOOKUP(C2,Sheet2!A4:B12,2))
to look up a reference code for "pipe". The reference codes for "pipe" are in column 2 of a table on sheet 2 and are dependant on the dimensions of the pipe given in column 1 of the same table. C2 in the formula is where the dimensions are given. (hope that's clear ).

What I want to do is to extend the above formula to look up column 3 of the table on sheet 2 if, for example, A2 contains "Bend", i.e., =IF(SEARCH("Bend",A2),VLOOKUP(C2,Sheet2!A4:B12,3)).

Combining those two formula using "=if(and " worked for me for the first test, but changing the contents of A2 from "pipe" to "Bend" results in a #Value type error.

I can't use if A2 = "pipe" because extra words could be introduced into A2, e.g., "copper pipe" - therefore the equals would not be appropriate.


View Replies!   View Related
Multiple Condition IF Statements (combine Them Into One)
I have 4 IF(AND) conditions that work fine separately but I can't seem to combine them into one.

=IF(AND(H56="New",I56="RE",Q56<=5),YES,NO))
=IF(AND(H56="New",I56="NON",Q56<=1),YES,NO))
=IF(AND(H56="Renew",I56="RE",Q56<=3),YES,NO))
=IF(AND(H56="Renew",I56="NON",Q56<=2),YES,NO))

View Replies!   View Related
Combine Data From Multiple Cells ..
Is it possible to combine datas from over 200 cells (all cells are from the same row) in one cell? I have tried CONCATENATE function and e.g. =A1&B2&... but is there shorter formula for this?

View Replies!   View Related
Combine Data From Multiple Columns In To One
I have attached a spreadsheet. I have a data set with ID's in column A and data in columns to the right. If an ID has only one entry then there will only be a value in column B if an ID has 2 entries then there will be a value in Columns B and C, if they have 3.......... And so on....

In my attached file I have created a macro that filters each column and copies the values to another sheet. If an ID had 5 entries (B-F) I would want to have 5 rows for that ID. The attached example macro does what I want but the real data has over 50 columns. Is there a more efficient way of doing this?

View Replies!   View Related
Combine Multiple Columns Into One On Another Worksheet
I am trying to combine the data of 31 columns into one column on a separate worksheet. The number of pieces of data in each column is different and as a result I am hung up on how to code the macro so that it automatically moves to copying the next column when a blank cell is reached, as it currently copies until it reaches the 100th row and then moves to the next column even though they're blank.

Sub CopyColumns()

Dim improw As Long, impcolumn As Long, MyCell
Dim ws1 As Worksheet, ws2 As Worksheet
Dim improw2 As Long, impcolumn2 As Long

Application. ScreenUpdating = False
Set ws1 = ThisWorkbook.Sheets("Data")
Set ws2 = ThisWorkbook.Sheets("Details")

'paste location on ws2
improw2 = 2
impcolumn2 = 2

There are column headers for the data on ws1 in row 2. The other thing I would like to do if possible is copy these column headers from ws1 onto ws2 by pasting them to the left of each piece of data (impcolumn2 - 1).

View Replies!   View Related
Combine Data From Multiple Worksheets Into One
I have 5 worksheets (all formatted the same) with data inputs from row 19 to 119 and columns A to BA. After row 119 I have several sums based on the data that is being entered on rows 19 to 119, I don't want this data being copied over. In most cases all rows from 19 to 119 will not be used, so I would only like to copy the rows that have data. To complicate matters, there are times when there will be blank rows within rows that have data. For example rows 19 to 25 will have data and 26 will be blank but rows 27 to 38 will have data. The blank rows are identified by column A (Job Number) being blank. This occurs because a job is dropped from the schedule and is no longer necessary.

In the end, I would like to have a button using VBA that will first clear the data in the new sheet (the sheet that is being populated with the information) and then re-populate it with updated data from the 5 worksheets.

View Replies!   View Related
Multiple Criteria: Combine All The Calculations
Is there any way to combine all the following calculations? Using the first as an example - If the word Resigned does not appear in P28 and if S28 = Q then the sum is 6 - 6*O28

=SUMPRODUCT((P28<>"Resigned")*(S28="Q")*(6)-(6*O28))
=SUMPRODUCT((P28<>"Resigned")*(S28="H")*(12)-(12*O28))
=SUMPRODUCT((P28<>"Resigned")*(S28="F")*(24)-(24*O28))

View Replies!   View Related
Combine Rows Into Single Cells By Condition
I'm importing some data from an HTML table into excel, it all formats pretty well except that some of the data appears on multiple rows.

A B C
1 01.02.06 John
2 Bob
3 Sam
4 02.03.06 Jim


What I need:

a b c
1 01.02.06 John, Bob, Sam 3
2 02.03.06 Jim 1

What I need to do is get all the items in the colum B which are listed under the same item in column a, in the first case John Bob and Sam and put them all into the same cell. I then want to delete the empty rows. It's important that this is done by testing to see if column A is blank, rather than using the date.

then in column C I want to count the items in column B,
ideally then repeat the script for the whole sheet.

Not a clue of the type of syntax I should be using though!
In fact there's probably a better way of importing the data from the HTML so it doesn't even need to be done this way! of course I'm oblivious to it. Auto Merged Post Until 24 Hrs Passes;Thinking maybe I didn't make myself properly clear....

If a cell in column a is empty then it means the item in column b needs adding to the end of the item in the row above in column b.

I then want to count the items in column b.

View Replies!   View Related
Combine Rows With Same Heading & Have Values Into 1
I am having 3 rows with same address and want to combine rows with equal names into single and delete remaing two rows

View Replies!   View Related
Combine Multiple Workbooks Into One Single Workbook
I am trying to combine ~300 workbooks into one single workbook. All 300 workbooks have the exact same header. I tried using the code from thread http://www.excelforum.com/showthread.php?p=696435 but nothing is being copied over. The only difference between my example and the other is I only need to take data from the first sheet in each data workbook. All the workbooks are located in following directory .....

View Replies!   View Related
Combine Data From Multiple Worksheets Into A New Worksheet
I have four worksheets that all contain the same header row in row 1, but different data in the data rows. I would like to combine all the data from each of the 4 worksheets into a new (created by code) worksheet named "WS Combine". The worksheet named "Result I want 01" simulates exactly what I want the "WS Combine" worksheet to look like. Can this be done?

The header row, however, only needs to be brought over once (with all formatting intact; ie header pane frozen, yellow, centered & bold).

The Worksheet named "Result I want 02" simulates the second thing I would like to do. This worksheet basically looks at "Result I want 01" and copies ONLY the rows that are RED and BOLD and pastes these rows (along with the header row). This worksheet could be named "Red Totals"

A couple of nuances...

1. The rows that are RED and BOLD in the four original worksheets are not always in the same position. That's because they don't currently populate that way so I wanted to make this as real as possible. Therefore, ideally, code that says "just copy all data from four worksheets" would not be sufficient.

If it's not possible or too involved to have the worksheet named "Result I want 01" reorder the rows this way when copying them over, then having them in any order is fine.

2. I need to keep the font formatting of ALL the rows intact as future code will not work without this formatting retained on the two new worksheets.

3. It is possible that duplicate rows can be created (two worksheets have the same exact data) when combining these four worksheets into one. If this is the case, then either allow that to happen or simply delete the duplicate row, whichever is easier.


View Replies!   View Related
Combine Sheets From Multiple Workbooks Specified In Table
I am trying to do is to combine multiple sheets from multiple workbooks if in the created parameters table it has a 'y' next to it. (So you can specify which workbooks to copy from and which worksheets to copy from) - please see example file to get a better understanding.

Example file:
Master

What I have is a parameters table which defines which workbook/worksheet to look in (please see attachment) on the 'parameters' worksheet.

I also have a 'raw data' worksheet within the same workbook where I want the combined data to go.

File a.xls/b.xls/c.xls etc

Theses are the workbooks where all the data is held which I want to combine, each workbook is the same, just different 'data'. - they are all in the same path too.

In the first column in the parameters table I have the available workbooks:
a.xls
b.xls
c.xls
etc
and next to it a 'y' or 'n' - 'y' if I want to copy data from that workbook or a 'n' if I dont.

In the second column in the parameters table I have the available worksheets:
sheet1
sheet2
sheet3
etc
and next to it a 'y' or 'n' - 'y' if I want to copy data from that worksheet or a 'n' if I dont.

In the attached example I have code which loops through each file a,b,c dependent whether it has a y/n next to it but I need some code to get it to copy data from the specified sheets in the second column (if it has a Y next to it) in the parameters table to the raw data worksheet in the master workbook with the filename of where the data came from in column A (eg A.xls).

View Replies!   View Related
Combine Or Nest Multiple Lookup Functions
I've got an indexmatch that works great
=IF(ISERROR(INDEX(accountstaff,MATCH(B$20,INDEX(accountstaff,,1),0),MATCH($ A55,INDEX(accountstaff,1,),0))),0,INDEX(accountstaff,MATCH(B$20,INDEX(accou ntstaff,,1),0),MATCH($A55,INDEX(accountstaff,1,),0)))

But I need to incorporate IF statement based on varying levels of revenue and think VBA will be less cumbersome, but don't know how to combine else if and index match.

I am trying to accomplish this:
IF B$20 (which is a dollar amount is = X, then index, match....
IF B$20 is > Y but < Z, then index, match...



View Replies!   View Related
Combine Multiple Sheets To Create One Table
I need to combine the category sheets back into one main table, knowing that there may well be an increase in the number of categories, as well as the number of rows in each category sheet.

I have attached a sample workbook - if anyone can help me with the code so that when the macro is run, the data in sheets A, B and C are combined into Main Table.

the macro would also then update the Pivot table, that would be the icing on the cake (I have shown the pivot table configuration I need, in this case using only the data from sheet 'C', for reference)

View Replies!   View Related
Combine Rows Based On Account Number/product No
I am curious if there is a way to combine the content of rows based on a change in account number(column A). The tricky part of it is that an account number could be in the file once and another could be in the data twelve times. The list is sorted by account number. I want to take the product code and description and keep placing in the combined row for each account number. Attached is a sample of the data.

View Replies!   View Related
Find Duplicates In Column & Combine Onto Same Row
I have a unique id in column A on a sheet with 20,000 contacts. I need a VBA script to loop through the worksheet and when it sees that there is a duplicate in column A, it needs to take the data from columns B, C, and D of that duplcate and copy them to the first blank cell at the end of the original record. Then it needs to delete the row that contained the duplicate that it just copied. I have searched and found parts of code that will do some of these, but I can't get anything to work, I don't know VB enough.

View Replies!   View Related
Combine Cells Compare & Delete Row
I have a data output from citrix that looks like the top half of the attached file. Each ID has 2 rows of data; open orders & recommended orders. Is there a macro that can sum up the two rows of data on to the first row (the one with ID and description in Collumn A & B) and delete the row afterwards, leaving only one row of data (format can be seen in the bottom half of the attached file). The original citrix report has hundreds of product IDs, which may vary from month to month. Original Format.xls

View Replies!   View Related
Combine Data From Multiple Worksheets - Pivot Tables
I am trying to combine sorted data from 2 worksheets to a new work sheet to process further. I have one worksheet with order number, part number, order qty but with different delivery dates. On another worksheet, I have the order number too, part number, the qty delivered. The qty delivered is not always the same each delivery.

My aim is to find out how many are already delivered under a certain purchase order and the balance of undelivered parts.

I used pivot tables to sort out the data but I am stuck here not knowing how to extra the sorted data from the pivot tables to the 3rd worksheet. I will need to match the order number and the part number.

View Replies!   View Related
Combine Multiple Files Into One Workbook (single Worksheet)
I've pieced together code from a number of solutions on the forum and figured out how to find the files I need to process, but can't seem to figure out the code to actually combine/append each worksheet into a single one. I've searched the "sea of options" on this forum and managed to do one thing well. Pardon all my notes embedded in the code below, but if I don't do it that way, I'll only confuse myself further (which is easily accomplished) ... or lose my notes!

Im going to run this code from an add-in menu, which is already created and working (yeaah!) so (I think) I need to have the code either create a file named "Master (Combined).xls" in the target folder ... or ... have a file already created in MYFOLDER and have this code delete all but the header row when the file is opened(???) The "Master (Combined).xls" workbook needs to consist of one worksheet named "Master". I want it to open the current workbook (.foundfiles(i)), select all the data, and append it to the master workbook on the "Master" worksheet (sheet 1). The Master Worksheet in the Master Workbook needs to start out as a blank sheet ... except for the header row. I can add code to put the headers in at the start, if necessary

Sub g_CombineMultWB_AllXLSFiles()
' This Will combine all XLS files located in the
' S:DMSMSPOMSMaster POMS NIIN DataMaster EMALL Data FilesEMALL Excel Folder
' into a single worksheet in a newly created (or previously existing) workbook
'
' LOCATION OF FILES (ACTUAL):
' S:DMSMSPOMSMaster POMS NIIN DataMaster EMALL Data FilesEMALL Excel Folder

Dim i As Integer
Dim wbResults As Workbook
Dim wbCodeBook As Workbook
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
' Application.CutCopyMode = False ' DO I HAVE THIS HERE FOR A REASON???

On Error Resume Next

Set wbCodeBook = ThisWorkbook
Const MYFOLDER = "S:DMSMSPOMSMaster POMS NIIN DataMaster EMALL Data FilesEMALL Excel Folder"
With Application.FileSearch
.NewSearch
' Change path To suit.............................

View Replies!   View Related
Multiple Ccolums/rows To Get Data From Multiple Columns/rows (vlookup)
I have created a spreadsheet to show some reports and I wanted to serch for some datas which overloops themeselves. If you can have a look at a test file I attached you will see the full picture. I have 2 tables, where the 2nd one is on the right side of the 1st one. 1st table:..............

View Replies!   View Related
Copy All The Rows Until Row 37 And Move It One Row Up After The Selected Row Is Deleted
enables the user to select a row to delete. However, I need to do more than that. I need to be able to copy all the rows until row 37 and move it one row up after the selected row is deleted. Below is the code

View Replies!   View Related
Odd Chart: Combine Data From Multiple Worksheets And Make A Chart
I am trying to combine data from multiple worksheets and make a chart. I have about 200 keywords in every worksheet (about 50), and some of them repeat themselves through worksheets and some don't. For every keyword, I have an associated value in the next column that I want to portray over time (each worksheet is for a different period).

So what I need to figure out is how to be able to pick any 10 keywords from the worksheets and put them in a line chart where I can see the associated value for each period for every worksheet so I can compare my keywords' efficiency. The tricky part is that some worksheets do not contain the keyword and other worksheets contain the keyword in a different cell than the previous wsheet.

View Replies!   View Related
Combine Rows Within Column Ref Another Column
I've got a good-sized single sheet workbook (A1:I8851) that I need a fairly complicated (seems like it to me, anyway) macro to get data in line from column to column. Here's what I've got:

Column A is titled "Category", and Column D is "Description". The actual category listings are in merged cells, spanning anywhere from 5-12 rows. Column D has no merged cells, but many (not all) cells in D contain data carried over from the cell above it (instead of wrapping the text, for some reason it just inserted into a new cell). The number of merged cells in A is equal to the number of unmerged cells in D.

I need a macro to combine each of the multiple rows in D into one single row, stopping and starting over when it reaches the next Category row. That way each category will have a single description line without incorporating parts of the description from the category above or below it.

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved