Auto Delete A Line

Jun 12, 2008

How would you make a macro that would delete the line if a field in that line say for example K1:K100 had "XX" or "XXX" in it?

View 10 Replies


ADVERTISEMENT

Get (tabs) Of Action Log To Auto-populate And Auto-delete In Master Log

Jul 29, 2014

I need the tabs of a project action log to auto-populate and auto-delete in a master log. (So when something is added or deleted in a tab it is added or deleted on the master) I use excel a little bit for work and personal finance purposes but I have zero experience with macros or VBA.

View 1 Replies View Related

Auto Complete And Auto Delete With Data Validation

Jan 7, 2008

Within a data validation selection, are you able to do both Auto Complete and Auto Delete? I have this posted at another forum [url]but have not been able to find a solution (a copy of the file, test. zip is there as well). I am not sure it is possible, or, at least I have been unable to get it working. I can do each, but not both.

I have also been utilizing:

[url]

[url]

View 5 Replies View Related

Auto Add Line On 2nd Sheet

Dec 20, 2012

I'm creating a Master document that has static information on one Source page that feeds to other sheets: Source contains name, address, contact, etc., that feeds to all other pages, budget feeds to invoice sheet, which feeds to contract, etc. Is there a way to copy information from one budget sheet and then automatically insert lines in invoice sheet?

View 1 Replies View Related

Delete A Line.or Rather A Line On A Line

Apr 8, 2008

I have a spreadsheet where there is a white line that is over a row line. No matter what I do I cannot seem to delete it.

I zoom in but I cannot select it.

I change the border of the cells and it will not disappear.

I am completely lost as to what else it could be, no doubt it is a simple answer that is staring me in the face. I inherited the spreadsheet so not sure what was done in the past.

View 9 Replies View Related

Auto Add Formatted Line With VBA Code

Jan 22, 2013

Need vba code for excel that will auto add a formatted row when a button is pushed? I have the button made, but I need it to move down a row each time a user clicks the add line button.

View 3 Replies View Related

Delete The Line On Worksheet?

Jan 23, 2009

Need to delete the line on this worksheet and post how they did it.

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

Look For Cell Value And Delete Line

Mar 4, 2013

I have seen so many examples online but none of them give the way to look for a value that I will input on a pop box.

In other words the macro will ask user for what value to look for. Once input then macro will run and delete row if value found if value is not found then return error and stop macro.

View 9 Replies View Related

Draw And Delete 1 Line

Mar 7, 2014

I have this Command button that switches on and draws a line. If you press it again then I need to delete that line.

If I push the button multiple times Excel keeps changing the name of the line. I have multiple lines on the same worksheet and text boxes but only this 1 line needs to be delete. I would think that theres a way to assign a permanent name to this line and delete and recreate it but...

ActiveSheet.Shapes.AddConnector(msoConnectorStraight, 319.5, 77.25, 319.5, _
245.25).Select
With Selection.ShapeRange.Line
.Visible = msoTrue
.Weight = 1.25

[Code]....

View 3 Replies View Related

How To Delete Specific Word From Every Line?

Sep 9, 2013

For example, on cell A1 I have 123456 Total, how do I delete the word "Total"? I have abut 2000 lines. What formula do I use?

View 5 Replies View Related

Delete All Rows/Data Above This Line

Nov 20, 2008

Let's say I have the following file which is imported via a macro which comes from a txt file. [Apologies it's 7mb zip file] http://www.fileden.com/files/2007/8/...mpNotFixed.zip

The way the txt file is that two rows make up one row, but SAP spits the data out into two rows. Now there are specific things that I need from these tabs. The way i can get this data is to perform sort by descending on the tabs. When you sort by a descending you get the data that i need [at the second half of the worksheet]:

Basically what I want to know when i create a macro, how can i get it do delete all the rows above a specific row. In the attached file, go to DataImport2.
I would like a macro to find the word "English" in column C and then delete all the row's above it. I cannot record this because it copy's the specific cells, which i do not need. DataImport3 is how the data comes out, All i do is sort by descending ... and i need help as stated above to delete all unnecessary data.

View 3 Replies View Related

Delete Last Line In Text File

Jun 19, 2007

I use the Append command to write a line to a text file. I have about 3 excel files appending data to the same text file.

If someone were to write a line in error I would like to have the ability to delete it.

View 3 Replies View Related

Delete Part Of A Text Line With Excel?

Jan 29, 2014

I have a text document with 1000 lines. All the lines are in this format

important< %#$ other words
other important thing < %Z$different words
some important text < $# some other words

I want to know if is such a excel filter that will delete all the characters starting from "<" until the end of the line.

So, the output of this 1000 lines will look something like this:

important
other important thing
some important text

View 4 Replies View Related

Looping Macro (delete Every Other Line On A Spreadsheet)

Jan 16, 2010

How do I write a macro that will delete every other line on a spreadsheet? I can create a macro that delete one line using the Record a macro command but what do I ad at the end of the macro to keep it going until stopped with Ctrl Break?

View 13 Replies View Related

Macro To Delete A Line In Inventory If Item Is 0

Feb 6, 2014

I manage an monthly inventory spreadsheet with over 100 various items in the master list. However in any single month there may be only 5 or 10 active items that need to be reported on. How do I develop a macro that will check the "items on hand" column and delete the entire row if the quantity is "0". My report is limited to showing only items on hand and not the entire list of items.

View 1 Replies View Related

How To Delete Line / Label Segment Between Two Datapoints

Dec 10, 2013

On this chart, I don't want to display the steep line segment between the first and second datapoints. I only want to display the datapoints. I also want to not display the segment of the label associated with this segment.

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

Userform: Delete All Content Through Double Click But Not The Highlighted Line

Jan 7, 2010

I have a worksheet in whichs Column A Cells , there is corresponding string content in Col. Z. Some cells of column Z contain of many lines (up to 100 line) which i want to reduce to one. I want to select one line through double clicking in the listbox of the userform and all other lines should be deleted and only the clicked one should remain. Code should then jump to the next non empty Z cell.

Columns B, C, D, E, F, G and H should also be shown in the userform and they should be live editable. I have attached and example file with userform and example data.

View 10 Replies View Related

Excel 2010 :: Macro To Delete Last Line Of Data In Each Worksheet In Workbook?

Apr 24, 2014

I'm trying to create a macro that will look at each worksheet in a workbook and then delete the last line of data on each worksheet. The last row can vary on each worksheet. This is what I have come up with but it is not working. I am on Excel 2010 and Windows 7.

Sub Macro1()
Macro1 Macro
Dim ws As Worksheet

[Code]....

View 2 Replies View Related

Auto Delete Row

Jul 13, 2009

I want create an conditional delete macro i.e.: if in column a - b - c the cell is not coloured = delete.

View 3 Replies View Related

Auto Delete Records In Excel?

Mar 23, 2012

how to automatically complete with Excel the following task:

1. I have two email databases in Excel: a master database and opt-out database.

2. I need to remove from the Master database emails of opted-out people.

3. Since the databases are large, I'd like to use a relevant Excel function to do that automatically.:

In the master list (column B) I have all the emails from the Master list. I have copied in the column C of the Master list the emails of all who opted-out. I need to remove opted out emails (listed in column C) from the master email list (column B).

View 1 Replies View Related

Delete Auto Open Macro

May 28, 2008

I have a excel file in which , there is probably a macro which runs when i open the file. The macro checks for a particular file on the D: drive.

I want to delete this macro. The problem is i cannot delete this macro, as it is not appearing in the Macros List.

Also i know i can disable this macro, by pressing the shift key whenever the file is opened.

But i want to delete this macro permanently from this file. I have tried various options like pression Alt-F11 & to locate the macro in module etc & also tried to locate it in the Workbook open event handler. But I cant see the macro.

How do i locate this macro & delete it.

View 9 Replies View Related

Speeding Up An Auto-delete Macro

Jul 14, 2008

Delete rows where column A and B are duplicated.

However, this runs extremely slow. I had to stop it after about 10 min, as it only got to about row 1000 of 20,000.

Sub Delete_Dupes()
Dim rw1 As Long: rw1 = 1
Dim rwx As Long: rwx = rw1
Dim stepx As Integer
Dim co1 As Integer: co1 = 1
Dim co2 As Integer: co2 = 2
Dim bool1 As Boolean
Dim bool2 As Boolean
Dim bool As Boolean
Dim count As Integer
count = 0
Do Until Cells(rwx, co1) = ""
stepx = 1
If rwx > rw1 Then
On Error GoTo NewCrit
bool1 = IsError(Application.WorksheetFunction.Match(Cells(rwx, co1), Range(Cells(rw1, co1), Cells(rwx - 1, co1)), 0))
bool2 = IsError(Application.WorksheetFunction.Match(Cells(rwx, co2), Range(Cells(rw1, co2), Cells(rwx - 1, co2)), 0)).................

View 9 Replies View Related

Auto-Delete Cell Value After Selection From List

Apr 24, 2009

i'm looking for is that I have two lists via Data Validation, and when someone changes their selection in list A, i'd like for list B to auto-delete whatever value it had in it.

Also, on a different topic, i'd like to know how to hide certain sheets in a workbook from public view.

View 3 Replies View Related

Dual-Condition Row Auto-Delete Macro

Jul 10, 2008

I browsed the first few pages of searching for "row delete macro" and couldn't find anything that suited my needs very much, so here goes:

What I need to do is automatically delete rows where the entries in column B (date) and column E (string) are the same. It is a very large group of data, so filtering is not exacly an option here.

Here is the twist on it...

I have a column F that contains either "Accepted-Active" or "Accepted-Closed". If I delete a bunch of rows that contain the same column B and E entries, I want to save the row that contains "Accepted-Closed", otherwise I don't particularly care which of the rows is saved.

View 9 Replies View Related

Auto Delete Rows To The Top Of The Sheet After Find

Sep 12, 2008

1) Highlight column A, and do a search on the word "Item"
2) Once it finds the word item, move 2 rows above it, and delete all rows above the word "Item"

The word Item at times can be on any row, and its very random, but its always in column, A. I tried doing it with a regular macro, but it seems to remember the row that I used, rather than two rows above the word "Item".

View 9 Replies View Related

Auto Delete Cells Which Is Filled With Color

Oct 12, 2008

vba to auto delete cells which is filled with color. e.g if from c39 to d39 is filled with lavender i want a vba to delete cell c39 to h39 until all cells with lavender is deleted. If there are other threads like this please direct me.


0.00 00 0.00 00 0.00 00 0.00 00 0.00 00 0.00 00 0.00 00

View 9 Replies View Related

Before Close Event (delete An Auto Correct Rule)

May 1, 2008

I'm working on a time sheet, and to make it easier to enter time i created a macro that sets the auto correct to correct a "." to a ":", but when the workbook closes i want to run a macro that deletes the auto correct rule.

View 13 Replies View Related

Auto Find Words And Delete From Selected Cells

May 20, 2009

it's possible to select a group of cells, or a column, and then have specific words (and the colon), like Email: Tel: Fax: and URL: found and removed?

I've got a list of contacts one after the other in a column like this

John
Accountant
456, Hillside Drive, Hamley
Tel: 09189374884
Fax: 0284764654
Email: john@email.om
URL: ww.johntheaccountant.com

The number of lines per contact isn't always the same.

Can it be done without Macros?

View 9 Replies View Related







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