Combine Cells Compare & Delete Row

Jan 9, 2007

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 2 Replies


ADVERTISEMENT

Delete Unwanted Row And Combine Different Cells

Apr 20, 2012

ItemNew or UsedQuantityDescriptionScrap ReasonActionitem1new1000item1 description1item1 reason1item1 action1item2new1200item2 description1item2 reason1item2 action10000item2 reason2item2 action20000item2 reason3item2 action3item3used3500item3 description1item3 reason1item3 action1000item3 description2item3 reason2item3 action2

The above was imported to Excel from another software and somehow those unwanted rows with "0" were created.

Would like to delete those unwanted row and combine the reason on those rows into their respective rows above.

Please note: this is just a small part of the file. The file is big and row with "0" doesnt occur in a prodictable patten.

View 9 Replies View Related

Compare Three Cells And Delete Row

Jul 25, 2008

I am trying to write some code that will compare three cells on a row and if they match then it will delete the row.

Column U-has Y, N entered
Column V-has Y, N entered
Column O-has 1, 2, entered (some cells may have the fill color set to red)

I need the macro to look at Column U and Column V and for example if the cell U2 has a N, and V2 has a Y then the macro would look at O2 and it there is a 1 with the fill color set to red the macro will delete that row.

The spreadsheet will vary on how many rows it contains. It can contain up to 5,000 rows and the macro would need to go through all the rows.

View 9 Replies View Related

Compare Two Cells And Delete Row If Text Is True?

Apr 6, 2014

Find the attached : example.xlsx‎

My requirement is compare two cells a1 & a2 if found true highlight a2,compare a2 & a3 if found same highlight a3 or compare a3 and a4 and repeat the same for the entire sheet.

View 1 Replies View Related

Compare And Combine Data

Apr 21, 2009

The data in each worksheet is from different programs that I need to combine. The first worksheet contains student mailing address information and the second details of payments for a specific purpose. Both worksheets has common data that is the student number. We have around 960 students and I can have anywhere between 400 and 20 students paying within any given month.

Below is an example of what I need, Sheet3 being the end result. I don't care if it is easier to combine both sheet1 and sheet2 completely and need to delete columns or move anything around (that takes no time).

I have tried to research how to do this but as I have no programming experience I have been unable to get my head around it.

View 4 Replies View Related

How To Compare And Combine Data From New And Old Product Lists

Mar 19, 2014

I have two spreadsheets full of products one of new products and the other of old products. I want to filter out the old ones that are discontinued but keep the ones that are still there. The old list has data I want to preserve for the new listings that would be duplicates from the old ones. I want to delete the new listings that already exist in the old list. I'm not sure exactly how to do it. I tried to delete dups based on product id or name but I'm afraid it's deleting entries I want to keep. Both lists contain over 5000 products each. I need to compare two lists and filter out the old products then work on removing the dupes.

View 3 Replies View Related

Compare And Delete Macro

Oct 22, 2008

Attached is a sample data set. If all the positive and matching negative entries are located and removed, there are 4 remaining entries. The only pertinent columns are A through J, the columns after that are where my fiddling is occurring.

First you have to highlight all the data (including the control columns to the right). Then, my macro sorts the data by the absolute value (found in column O), allowing the formulas in N to then properly mark all negative entries with an "X and all the ones that now have a matching positive entry directly below it with an "X".

Then my macro hides all the fields with an "X" in column N. There is a macro called "CLEANSE" that does this, but only hides the rows. I keep messing up when I try to delete them entirely.

Can someone correct my macro so it will properly delete the rows with an "X" in the N column, or suggest a better macro that will scan the E column and flag matching positive/negative numbers and delete them without my control columns N and O?

View 3 Replies View Related

Compare Two Columns And Delete Duplications?

May 28, 2013

I have a spreadsheet with 4 columns.

I would like to Compare Column A with Column B, if Column A contains text or numbers anywhere in Column B, then remove the corresponding rows not just in Column B, but Column C and D as well for that row.

View 3 Replies View Related

Multiple Sheet Compare And Delete

Nov 2, 2009

I have several (Child) sheets of data which I need to compare to a (Parent) master sheet. If a cell in column "A" on a child sheets matches a cell in column "A" on the parent sheet, I need the row on the Parent sheet deleted so in the end, only the rows with no Child matches are left on the Parent sheet.

View 4 Replies View Related

Modified Compare And Delete Across Sheets

Nov 4, 2009

This compares cells in every sheet to a master sheet "AllUnits" and deletes all the matched rows on the Master. I modified it slightly to also delete the matched row on the source sheet as well (looking for rows that are not matched on any sheet). This works to a point, but I have to re-run it many times since when the source row is deleted, the code actually skips to the next row. I tried to reset the source variable with

View 2 Replies View Related

Compare Sheets And Delete Same Items

May 18, 2006

I have two sheets with about 7000 records in each. They both have two columns only. One is the master list. I want both of the files to be compared and then all the duplicate entries to be deleted from both files.

Ultimately I want to have only the entries in the master sheet that are not in the other sheet.

View 3 Replies View Related

Find, Compare And Delete From 2 Columns

Feb 8, 2008

I an using Excel 2003. In that i am having 2 columns (A&B). I need to take each value from Column A and search that cell value in Column B. If it is not found in Column B then delete the cell data in Column A. Then take the next cell data in Column A. Find operation and delete if not found. Do it for entire rows in column A. Then repeat that for Column B also. So my final result will be the same cell value in Column A and B. I need VBA code.

View 2 Replies View Related

Find In 2 Columns, Compare And Delete

Feb 20, 2008

I an using Excel 2003. In that i am having 2 columns (A&B). I need to take each value from Column A and search that cell value in Column B. If it is found in Column B then delete the cell data in Column A. Then take the next cell data in Column A. Find operation and delete if found. Do it for entire rows in column A. Then repeat that for Column B also. So my final result contains uncommon cell value in Column A and B. I need VBA code.

View 3 Replies View Related

Compare Two Columns-delete Duplicates From Just ONE Column

Oct 7, 2009

I have column A that is 1,500 records.
I have column B with 40,000 records.

Among the 40,000 records in column B, duplicates of ALL 1,500 records from column A exist.

My question is: How do I find WHERE the 1,500 dupes are and how can I delete JUST those records?

View 3 Replies View Related

Compare Dates In Rows - Delete Then Shift Up

Mar 14, 2012

I am fitting 2 sets of data to match eachother. I want to have as much data as possible but only for the same dates of each dataset.

I have 4 coloumns.
Dataset 1: A is date B is data
Dataset 2: C is date D is data

I want to compare A vs B one row at a time. If they are not similar it should delete and shift up the values in A+B or C+D according to the lowest value (date) of A vs B.

Remember that if the macro just deleted and shifted up it should compare the same (undeleted) value against the new value that just shifted up in the other coloumn.

View 2 Replies View Related

VB Code To Compare/delete Rows Of Data

Feb 4, 2007

VB code to carry out the following task?

Look at name in cell BC2, check the name in cell BA2 and if is the same delete the name in BA2 and BC2.

If is different then leave both cells as they are and move onto checking BC3 against BA3
carry this loop thru BC2 : BC40

View 9 Replies View Related

Compare Dates Against One Date & Delete Rows

Nov 24, 2007

I have a column of dates (B2:B1500) that I want to compare to a single date (A1).

If the dates in Column B are older than the date in A1 I want to delete the entire row.

View 3 Replies View Related

Compare Columns & Insert / Delete Rows

Feb 22, 2008

I have a large data file. In column A is 8760 entries (every hour of every day of the year). Columns D & E are linked, Column D is the time and date whilst Column E is a parameter assocaied with that time and date.

There should also be 8760 entries in these columns, however there are some missing data lines in columns D & E. I would therefore like to move the rows in columns D & E so they match with the entries in column A. Can anyone help? I have a headache as i have over 70 files to complete this operation on.

View 9 Replies View Related

Macro To Combine Cells In A Row To 1 Cell While Skipping Blank Cells

Jul 2, 2014

I need to combined all non blank cells in a given row into 1 cell. But within each row i have 5 phases that the values fall into, which is denoted by the 1st charter 1, 2, 3, 4, or 5. for example, in a given row i have 1-a, 1-c, 2-d, and 1-f and these values occurs in non consecutive columns starting from G to ALR. I need a macro that sorts these values in one of the 5 phases. So in another sheet the macro would combined [1-a 1-c 1-f] in Phase 1 and [2-d] in phase 2. and if there are other phases it would put them in the appropriate cell.

See attached workbook : Work Order Summary Sheet.xlsx‎

View 3 Replies View Related

Macro To Combine Cells In Row To 1 Cell While Skipping Blank Cells

Jul 17, 2014

However, in addition to what the macro already does, it is possible to add another work sheet in the same work book that outputs the values in separate cells? It also has to output the data in order: for example, in the first work sheet the data is inputted at random and has spaces but the macro will have to remove all the blank cells and output them in order based on the first value in the test string, 1, 2, 3, 4, and then 5;

input:

blank 3-x Blank 1-y blank 2-z 1-k

output:

1-k 1-x 2-z 3-y

View 4 Replies View Related

Compare Number Lists On Different Sheets And Delete Duplicates

Mar 26, 2011

Need to find a column of numbers from one worksheet and delete them from another.

Example
To be deleted is below:
83221
83223
83232
83233
83236
to be deleted from is below:
83221
83223
83226
83227
83228
83229
83230
83232
83233
83234
83235
83236

Another issues is that the worksheet that needs to have the numbers deleted from has 3 columns total so the whole row would need deleting, or if its easier I could replace the numbers with 0 and then sort and delete.

View 9 Replies View Related

Compare 2 Columns Delete Rows With Matching Values

Feb 5, 2009

I've got two workbooks, Workbook1 with a list in column a and Workbook2 with a list in column F. I want to compare the cells in these columns and delete the entire row in Workbook2 if there is a match.

View 3 Replies View Related

Compare The Two Lists And Then Delete The Cleared Checks Off The Original List

Mar 18, 2008

I am trying to create a way to easily maintain a list of outstanding checks. I am able to import cleared checks into the spread sheet but cannot find a way to compare the two lists and then delete the cleared checks off the original list.

View 2 Replies View Related

Combine The Cells In A1

Nov 26, 2008

In cell B1 I have the number 1
In cell C1 I have the number 1031000

I know how to combine the cells in A1. I am getting a result of 1-1031000

What I would like to happen is that 1 becomes 001.

Ending result is 001-1031000

problem is that cells in B could be one, two or three digits.

On a small scale I could fix manually but i have over 15,000 rows to deal with

View 2 Replies View Related

Combine The Cells

Oct 15, 2009

i m working on a spreadsheet and i need cell A+B=C..

Example
Cell A has a first name (John)
Cell B has a last name (Smith)
Cell C has last name then first name seperated with comma

View 4 Replies View Related

Combine Three Cells Into One?

Jan 23, 2013

Is it possible to combine three cells into one? Like for example, column A is the first name, column B is the middle name, column C is last name.

Is it possible put it on a format like this: Last, First M.

(middle name on column B is a name, not an initial.)

And can I make it only the first letters are capped. Last, First M. Or all small letters. last, first m.

View 7 Replies View Related

Compare 2 Columns & Delete Rows Ouside Scope & Show Formula Result In Message Box

Jan 22, 2008

I have the following code to compare two columns and delete adjacent rows if 1 is greater than or equal the other...

Sub LastReceipt_GT_Confirmed()

Dim intLstRow As Integer

For intLstRow = Range("E" & Rows.Count).End(xlUp).Row To 2 Step -1
With Range("E" & intLstRow)
If .Value > .Offset(0, 1).Value Then .EntireRow.Delete
End With
Next intLstRow
For intLstRow = Range("E" & Rows.Count).End(xlUp).Row To 2 Step -1 .............

View 9 Replies View Related

How To Combine Multiple Cells

Dec 27, 2013

I have a data set that I am generating from a SQL database then putting into excel format. In this spreadsheet, I have a one to many ratio. I want to combine all notes associated with the same applicant_id into one cell. I also, only want the first Received Date and first Entry date that comes across. Is this possible to set up a formula/macro to do this manually for me? Each day I generate this data set, the number of entries can vary. I provided a smaller set, but I'm dealing with hundreds of entries.

ReceivedDateapplicant_identry_datenotes_comments
12/27/13 0:0788695812/27/13 9:07Primary Call
12/27/13 0:0788695812/27/13 9:07Left Note
12/27/13 0:0788695812/27/13 9:08Left Voicemail
12/27/13 0:09886959NULL
12/27/13 0:13886960NULL
12/27/13 0:14886961NULL

[code].....

View 2 Replies View Related

Combine Two Cells And Add Text

Feb 25, 2014

I want to combine two cells and add text. Then delete column D.

View 4 Replies View Related

Combine Two Linked Cells

Dec 1, 2009

I am making a report template in excel. I have written a macro to format the report based on the contents of two other sheets in the work book.

I am attempting to combine two cells in separate sheets as a linked cell in a third sheet.

i.e. in sheet 3, A1 I want to combine the values held in sheets(1).range("a1") with sheets(2).("A1") as a link which will update as the parent cells values are changed.

The cell has to be a link of the other cells as their contents will change based on the report requirements.

View 5 Replies View Related







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