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


ADVERTISEMENT

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

Trying To Delete Unneeded Sheets With VBA

Oct 30, 2007

I have tried the following two sets of codes trying to delete unneeded sheets with VBA.

1) Application.ActiveWorkbook.Sheets("PART").DELETE

2) Sheets("PART").Select
ActiveWindow.SelectedSheets.Delete

Neither of these deletes the sheets when I run my macro. I have Application.DisplayAlerts = False. Don't know whether that has anything to do with it.

View 9 Replies View Related

Creating A Line Graph With 2 Sets Of Values

Oct 21, 2009

I am trying to create a line graph to show the trends (up or down) of I-Fund vs Gold. The trouble I am having is how to set the axis. The date one is an easy one, but the gold range is more or less 800-1000, and the I-Fund is 13-18. How can I have these both on the same graph to compare? I am attaching an Excel sheet as a reference. Obviously I need to delete the empty IFund cells.

View 2 Replies View Related

Sum 2 Or More Rows And Delete Unneeded Rows?

May 9, 2014

I would like to write a macro button, in order to lookup through col. "D" and where find same invoice number (invoice number combine with 3 letters plus dash), should sum the corresponding rows' amounts in col."J" into one row and the other row should be deleted.

View 3 Replies View Related

Line Graph With 2 Lines Per Person?

Sep 15, 2013

I need to create a line graph that has 2 lines for each person, one with the amount, one with the points. The X-Axis is by Weeks going up. How can I do this without making a separate series for each? I've attached an example.

example.xlsx

View 1 Replies View Related

Delete The Whole Row In All Sets Of Data

Dec 13, 2009

In the attached workbook, I have identical sets of data in column A separated by an blank cells. I need a macro for user form that searches for an item indicated in the textbox of the form and then delete the whole row in all sets of data.

It is important to keep the blank cells between the sets constant, 4 blank cells between each set, except the first set that starts with 3 blank cells.

View 2 Replies View Related

Multiple Lines To One Line (Rows To Columns)

Aug 12, 2014

I have is a list of the over 500 people with one line per college degree. Some have up to 4 or 5 degrees. Each have SSN as unique identifier.

I need to consolidate into one like per person with multiple columns one for each degree.

See attached : Test Degrees.xlsx

View 6 Replies View Related

Insert 2 Lines Under Line 6 In The Active Sheet

Aug 27, 2008

I have to do a large amount of routine work with a large number of sheets. I have tried to record some macros to do the job.

First of all I would like to insert 2 lines under line 6 in the active sheet.

I then need to drag the formulas found in line 6 down over the two new lines.

Thirdly i would like to change the text string "xxx" in the formulas found in line 7 to "yyy"

View 9 Replies View Related

Place 1 Line Of VBA Code Into Mutiple Lines

Jun 11, 2009

I stumbled on this and wasn't sure why the code was placed on different lines and how the highlighted sections in red affect the basic round function.

ColorCompare = Round( _
(111111 + Blue + Red + Green) / (Green + LenPaint) _
, 0 _
)

View 3 Replies View Related

Transfer Single Line With Sum Of Multiple Lines

Oct 16, 2007

I import data into an excel spreadsheet where a unique job number may have multiple costs against it. These import as separate lines, repeating the job number.

The data imports on a sheet called 'DataImport'. From that sheet I transfer some of the imported fields onto another sheet.

What I need to be able to do is transfer the job number and a sum of the costs onto the other sheet.

The data is run regularly and I delete all the fields on the DataImport sheet in the macro each time the import is run.

View 9 Replies View Related

Delete Both Sets Of Duplicate Date?

Oct 8, 2008

I currently have about 3000 rows of data, much of it being duplicate data. Is there a way to have it search for duplicate data, and have it delete BOTH sets of duplicate data? For example, say this is what is in my spreadsheet:....

I would want it to delete both John Smith records and both Ted Nugent records, leaving Bob Bobbert's and Michael Jordan's records.

View 4 Replies View Related

Adding Grid Lines And Line Numbers In The Report?

Mar 4, 2014

See the code below. It works fine but in the report that gets printed off, it doesn't display grid lines and line numbers .

[Code] .........

View 3 Replies View Related

Excel 2010 :: Line Graph Isn't Charting Lines?

Feb 23, 2012

I have been trying to chart temperature differences over 10 day's time for six cities using a line graph. For some reason, the lines are all clustered at the bottom of my graph, with values of 0. My spreadsheet is accurate, without any blank cells. I'm using Excel 2010.

View 1 Replies View Related

Inserting 1 Line In Sheet1 To Enter 5 Lines In Sheet2

Jul 23, 2006

One has around 129 lines for the first years 2006 in sheet1.
The other links to the first 129 rows. Then I've linked the top 129 in sheet2 130 down for 2007 and so on for 5 years.

How would I add a line in Sheet1 then would insert 5 lines in sheet2 keeping the same order.

e.g

Sheet1
Name Rev Year
John 120 2006 Row 5
Jack 150 2006 Row 6

Sheet2 (linked)
Name Rev Year
John 120 2006 Row 5
Jack 150 2006 Row 6
John 130 2007 Row 134
Jack 160 2007 Row 135
John 140 2008 Row 263
Jack 160 2008 Row 264
John 150 2009 Row 392
Jack 170 2009 Row 393
John 155 2010 Row 521
Jack 180 2010 Row 522

The Rev changes by formulas in Sheet 1

View 9 Replies View Related

How To Convert Selected Multiple Lines Of VBA Code Into Comment Line

Jan 29, 2014

Adding ' in the beginning of a line converts the rest into comment line. I wonder if there is an easy way to convert a huge area into comment line to try something on code. I couldn't find such an option in the menu.

View 2 Replies View Related

Hit Tab Button To Insert New Line And Preserve Previous Lines Formulas

Feb 23, 2014

I am brand new and I don't know a ton about macros and programming in Excel.

What I'm trying to do here in this attached spreadsheet is at the end of inputting my line, I want to hit the tab (marked in red to make it clear where) button in the cell and have it automatically create another blank line but keep the formulas the same.

Basically I just want to avoid having to right click and insert line and then drag the formulas column by column down which is difficult.

See attached : TEST2_2014 Sales & Commission Spreadsheet.xlsx‎

View 5 Replies View Related

Broken Line Chart Code Turning Lines Black

May 24, 2007

creating breaks in the line this script now simply turns the line black.

View 9 Replies View Related

Select Series (lines) In Line Graph By Adding Userform With Checkboxes On A Chart

Apr 15, 2014

I want to add a user-form on a chart, which will have check-boxes that will allow me to select series(lines) that I want see and compare in a chart. Currently my line chart has 24 series (Lines) which makes the chart very difficult to view and looks very busy. How do I add list of check-boxes that will allow me to select one or multiple lines that I want to see at a time?

View 2 Replies View Related

Excel 2013 :: Merging Selected Lines In Worksheet To One Line - Removing Dupes?

Aug 12, 2014

I merged about 15 adresslists from media contacts to one excel list. Each list had a name i.e. music, health, theater, etc. and the same logic in colums. I added a few columns and have 1 large list now.

As some journalists write about music & health & theater, architecture, etc. they are listed up to 10 times in the new list now. But the "genres" from the original list i.e. music, health, theater, etc. are in different columns. Some of the lines have empty fields (i.e. no address or mail)

All I want to do is have one line with all the information of all 10 lines in it, merged, dupes removed:

company - firstname - lastname - Adress - Mail, etc. : genre: music - health - theater:
example.xlsx

I atteched an example of the full list and the result i want

View 9 Replies View Related

Macro To Enter Information On A New Line

Mar 14, 2007

I am creating a macro that will take some information from 3 cells that the user will input, place it into 3 different cells, clear the original 3 cells and then I would like the macro to, when next activated input the new information from the 3 cells below the information that was already in the table.

For Example,
Date (D3), Description (E3, F3, G3 Merged cell) and Reference (H3)

I would then like those 3 cells to be put into A9:E9 then clear the original cells. That is not the part that I have the problem well, the following however, is.

After I enter new information into the input cells, and press the macro button, I would like the information to be placed into A10:E10 and from then on, the information goes down by 1 row after each macro.

View 11 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

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

Trimming Unneeded Digits From A Chart Series

Dec 11, 2009

I have a scatter chart that is populated from the values on a worksheet. The series formula looks like this:

=SERIES(,{2.36655521392822,2.54071712493896,2.70576763153076,2.8779809474945,3.04913735389709,3.2250 7190704345,.........},{5,5.09999990463256,5.19999980926513,5.30000019073486,5.39923381805419,5.5,5.5 995168685913,5.69999980926513,........},1)

I really don't need all of those extra digits, at most 2 significant digits is all I need. I wrote a piece of code that looks like this to shorten each number but it is not working. The code runs and in the watch window I can see that each digit is indeed being trimmed and converted back to a number (vs. a string) but the chart series formula still carries all of those extra digits. What am I doing wrong here. The code I wrote is below.

View 4 Replies View Related







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