Merge 2 Lines Then Delete

May 16, 2008

I have a complex worksheet that I have some duplicates that I want to merge the data together with Daily. The problem is now the process is getting too long due to the data size increasing. Access will not be a feasible solution at this time.

Column A would have the matching info.
The cells I want to copy are in columns AM:AP

Way it looks now:

A, [Col B:AL], AM, AN, AO, AP
Product#, [B:AL], New List, ID, Vendor, Rep
07256,[Data I want to leave],,,,
07256,[Blanks],HighRisk,32,59,1732

Way I want it to look:

A, [Col B:AL], AM, AN, AO, AP
Product#, [B:AL], New List, ID, Vendor, Rep
07256,[Data I want to leave],HighRisk,32,59,1732

Delete the second row after the data was merged and look for remaining matchs to do the same.

After it is completed have a message box indicating the number of records that this was done to.

View 9 Replies


ADVERTISEMENT

Delete & Merge Columns,Delete Rows With Filter, Etc

Jul 15, 2009

1. Remove J,K,N,A Columns,

2. In the last O (TIMESTAMP) column, the date is 14-Jul-09 format change it to 07/14/2009 (this format mm/dd/yyy

3.Filter L column (VAL_INLAKH) Remove all rows from whole sheet which has 0 value

4. Column C (EXPIRY_DT) date format is 24-Sep-09 , "dd-Sep-09" change to "Sep" only

5.Merge Column B,C,D,E (SYMBOL.EXPIRY_DT.STRIKE_PR.OPTION_TYP
respectively )

View 3 Replies View Related

Delete 1 Line After Each 65 Lines

Jan 13, 2010

I have 2 columns in Excel wich havn't the same amount of lines.

One colom is 65.000 lines and the other one is 64.000

I am looking for a option to delete 1 line after each 65 lines.

Is this possible?

View 6 Replies View Related

Delete Lines From A Proceedure

Jan 16, 2009

I'm trying to remove a proceedure code or just line 3 if I could in the active workbook"ThisWorkbook" mod. However I'm having an issue with this code. how to remove all the code that is in "ThisWorkbook" mod? or just line 3 in that code. I have other mod that I want to keep. So I dont want to wipe out all the code from the workbook. Here is what I have but I get a sub or function not defined error.

View 2 Replies View Related

Delete Lines After A Bullet

Jul 7, 2009

I am attempting to write a macro that given a range of cells goes into each cell and deletes the text after the first bullet. An example of this would be:

The original cell contains: ....

View 9 Replies View Related

Macro Delete The Lines

Mar 16, 2008

I have 3 different sheets named:

USA
UK
DK

and 1 sheet named:

I would like to have a macro written that when runned will delete all data in line 2 to 1000 in the first three sheets and line 2 through 1500 in the compilation sheets

View 9 Replies View Related

Delete Empty Lines In VBE

Dec 1, 2006

i'm trying to tweak Chip's code [url] to include the body of the module as well.
it works, but when there's blank lines in-between modules it'd show less of the modules.

is there a way to delete the empty line in VBE?
or did i miss something out in the code below?

Sub ListProcedures()

Dim VBCodeMod As CodeModule
Dim StartLine As Long
Dim Msg As String
Dim ProcName As String

Set VBCodeMod = ThisWorkbook.VBProject.VBComponents("MyModule").CodeModule
With VBCodeMod

View 3 Replies View Related

List Of Values - Delete Lines

Apr 17, 2014

I have a list of values. they are in C2:C25

I want to go dorn column B, starting at B26:B, and if the value in B equals any of the values in C2:C25 than delete that entire row(not just delete the word, because there are values in column C and D that I need gone with the C value).

View 5 Replies View Related

Delete Lines In A Multiple Cell?

Aug 5, 2014

TTHBF251863100

147943F00KNQ TTHBF251863100
REF VINS DU MONDE SA
O/RTT HBF251863100

I need a macro to transform my multiple lines cell as above ( 5 lines ) into a one line cell as below.

REF VINS DU MONDE SA

As the cells needing changing will always be different it would be good if I could have a macro working on the selected cells only, not a specified range.

View 1 Replies View Related

Delete Lines From A Text File

Sep 7, 2009

I'm writing a macro in excel that edits a text file runs another program that uses this text file as its input and then stores the results. Perameters are then changed in the input file and it is then repeted over and over again. One of the parts I am stuck on is I need to delete the last 5 lines in the input file called INPfile.txt. See below:............

This section is always at the end of the file, is 5 lines long and always starts with [DEMANDS] and always ends with [END].

View 2 Replies View Related

Sum, Merge, And Delete Duplicate Row

Sep 24, 2009

I've been trying to sum merge, and delete duplicate rows in this massive spreadsheet (over 15,000 rows). Currently I've gotten to the point where the duplicate lines are eliminated but the quantity is recording the number of times the line has moved, not summing. Below is an example of what I'm looking for

EX:..............

View 3 Replies View Related

Delete Visible Lines That Meet Criteria

Jul 29, 2009

I'm trying to apply an autofilter to do the ol' "delete visible lines that meet criteria" trick. Unfortunately my vb macro, although applying the string correctly, hides all of the lines...

This is the part of code relevant to filtering (i'm trying to filter on column M which is 13):

View 6 Replies View Related

Delete Lines If Words Are Repeated And Hour Is The Same

Dec 23, 2008

I have tabulated data from columns A to I, in column B words different only in last letter, going from A to C,

column F=Date and column G=Hour, something like this: ...

View 9 Replies View Related

Delete Duplicate And Merge Data In One Row

Sep 27, 2008

I have a new project that needs macro code. Your help is very much appreciated. We have a spreadsheet with duplicate accounts meaning two or three rows with the same account but different information. We want to use only one row for one account and move the new data from the same account to one row only to the right and delete the duplicates. Can someone please help me with this?I read so many post and I tried some of them but it only delete the duplicate row and not copying the new data from that row to one row only. Also, the other code I tried was retaining only the current or old data. Actually, to elaborate more, I want to get the new data in each cell of the same account in multiple row and move it in one row to the right only and delete the duplicate in that same account.

View 14 Replies View Related

Merge Worksheets And Delete Duplicates

Jan 11, 2007

We receive huge Excel files and we need to validate for and delete duplicate records before they are imported to a software product called Exceed Premier. We are having a difficult time with Excel spreadsheet duplicate record validation because we have to first export the files from the Exceed database into an Excel spread, merge the thousands of other new records from multiple Excel files, then import back into Exceed.

Is there a method in Excel/VBA that can merge several worksheets and check for and delete duplicate irecords? The records will be in the 20-50K range and growing.

View 3 Replies View Related

Line Up 2 Sets Of Information And Delete Unneeded Lines?

May 15, 2014

I have 2 lists of codes with values tied to them, columns A & B, and columns C & D. Column A is a list of the codes in use, and column C is every code possible, I need to line up the codes and shorten column C to match column A, while retaining the value that is tied to each code so that I can compare Columns B & D easily.

View 2 Replies View Related

Excel 2007 :: How To Delete 655000 Lines Of Data

Sep 21, 2012

I have a public/shared Excel 2007 workbook on our network and someone colored an entire column yellow. When that happened, it increased the number of rows to over 655,000. I didn't know that was posible but they are there... The thing moves very slowly now and when I try to delete (45,000 lines at a time), I either get a error window telling me I don't have resources to perform the operation, or I do smaller chucks and after 30 minutes deleting lines, it will not save.

I would rather not have to recreate the whole workbook if I can delete the lines on this one page.

View 9 Replies View Related

Import Multiple Text Files - Delete Rows Between Lines With File Name

Apr 10, 2014

I have around 50 text files with similar design per attached file. I need to import the text files with criteria below:-

1. include file name
2. let user choose the folder
3. exclude data from "work in process summary" to "work in process cost totals"
4. only have one title in the excel files which all text files is combined "Item, Line ....."
5. If the text files do not have title like "Item, Line, ..." do not import

Is it possible to have all criteria listed above by running a macro?

A.txt

View 1 Replies View Related

Sum Lines Of VLookup?

Nov 22, 2012

I have a sheet which looks a bit like this

Day
A
B

Day
Cost A
Cost B

[Code]....

For each column with a header A, B (these are people), 1 in their column represents they works that day on a project. The day columns are days of the week, and people cost different amounts on different days. I need to work out the total cost for each person for the working period.

The cost for the first day for person A is =if(b2=1,vlookup(a2, f2:h8, 2),0)

How do I sum the costs for each day in a single formula without creating a cost per day column for each person i.e. sum each line of vlookups?

View 1 Replies View Related

Comparison Of The Two Lines?

Feb 19, 2014

I have two rows of data, each row also have similar data. I need to find the number of matches that the two lines For example :

7,7,K,A,8,7
K,6,7,7,A,9

To reach the conclusion I need to build six such functions:
=1*(COUNTIF($A$65:$F$65,A66)>=COUNTIF($A66:A66,A66))
=1*(COUNTIF($A$65:$F$65,B66)>=COUNTIF($A66:B66,B66))
=1*(COUNTIF($A$65:$F$65,C66)>=COUNTIF($A66:C66,C66))
=1*(COUNTIF($A$65:$F$65,D66)>=COUNTIF($A66:D66,D66))
=1*(COUNTIF($A$65:$F$65,E66)>=COUNTIF($A66:E66,E66))
=1*(COUNTIF($A$65:$F$65,F66)>=COUNTIF($A66:F66,F66))

The result is 4

Is there a single formula that will give the result ?

Another question, is there a formula that I can compare to the principle of one line against the 20 lines ?

View 8 Replies View Related

Duplicate Lines

Jan 1, 2008

i have a list of about 2,000 rows of text going down vertically, but out of that 2,000 there's only about 1,500 actual items - the rest are duplicates.

how would i go about eliminating the duplicate strings of text quickly?

View 9 Replies View Related

Two Lines In A Msg Box On Open?

Jun 20, 2009

I need a msg to pop up when a worksheet opens. Pretty simple:

Private Sub Workbook_Open()
If MsgBox("My msg goes here!") Then
Exit Sub
End If
End Sub

But I need to be able to have multiple lines, maybe a short paragraph.
How do you get it to allow additional lines?

View 3 Replies View Related

Excel Min And Max Lines

Aug 15, 2012

In Column B I have some measurements. These are measurements. I chart them in a line graph. I also have my max and min over in some other cells. These aren't the min and max of column, but these are what I have set the min and max at. To make this clearer, my max is 27, but the data in Column B could be anything....20, 28, 35, 15, etc.

I want to plot my data in Column B just as I am currently doing. However I also want to plot the min and max on that same line graph and show them has horizontal lines going across. That way, if one of my numbers is above the max (or below the min), you will be able to see it on the line graph.

Here's what my data looks like. The Viscosity (column b) is what I'm charting on the line graph and you can see the min and max data that I want to plot as well.

Sheet1

*
A
B
G
H
I
J

2
Batch No.
Viscosity
*
*
Min
Max

3
4028634
26.7
*
Viscosity
21
27

[Code] .......

View 9 Replies View Related

Comparison Of Lines

Jan 22, 2007

There are four lines of numbers, in all line 8 numbers.

1 1 2 2 3 1 1 2
1 2 3 1 2 2 2 1
2 1 1 3 1 3 1 2
1 2 2 2 3 1 1 2

I would like to find a function that will examine, if there are similar lines according to my definition, and several.

my definition is 7

For example that I gave, the result in the wanted function needs to be, yes (Line 1 and line 4) and several-One time.

View 9 Replies View Related

Unhide All The Lines

Apr 26, 2007

I have a file that contains at least 35 sheets. All of the sheets have some lines that are hidden. I tried selecting all the sheets and unhiding everything but it didn't work because some sheets actually have filters in them and the filter line is also hidden.

View 9 Replies View Related

Combine Lines

Jan 10, 2009

I have a text file which is wrapped and i am trying to read it through VBA. I want to combine wrapped lines in one line

for e.g.:

abcdefgh
ijklmno
pqrstu
vwxyz
need
abcdefghijklmno
pqrstuvwxyz

View 9 Replies View Related

How To Put Worksheets In 2 Lines Or More

Jan 14, 2009

Is it possible to have worksheets in 2 or more lines at the bottom of excel window?

View 9 Replies View Related

How To Get Together All Duplicate Lines

Oct 22, 2009

How to get together all duplicate lines? ...

View 9 Replies View Related

Add 2 Row After Each 9 Lines And Calculate A

Dec 28, 2009

I need a macro that add's after each 9 lines 2 new rows. The data I've it's not the same every month, one month I can have 27 lines the next one I can have 90 lines for exemple.

I need also to calculate in one of those added rows this "=B8+B4-B6". This calculation is to be apllied in each block of nines lines.

View 9 Replies View Related

Header Via Vba With 3 Lines

Mar 14, 2007

I manually added a center header to my report that take 4 lines

So I would like to repeat this using vba

Line1: Looney Tunes, Inc.
Line2: Bugs Bunny Subsidiaries, Inc.
Line3: Consolidated Rollup
Line4: FY 2007

Furthermore, I would like to read this from cell(s) as at least a 52 page report
and lastly I would like to alternate font sizes

Line1: 18 pt
Line2: 18 pt
Line3: 16 pt
Line4: 14 pt

View 4 Replies View Related







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