If Something, Then Delete Cell Content

Jan 8, 2010

I am trying to find something that will let me look at a Log Book Page (a Worksheet). I need it to look through Cells E4 trough E15 I want it to look for the 1st entry of 3 different materials.

3/4" Plywood
1/4" Plywood
3/4" Particle

These names are in a drop down menu from a different sheet in the same work book

Sheet Name link '.'!
'.'!A2 3/4" Plywood
'.'!A3 1/4" Plywood
'.'!A4 3/4" Particle..............

View 9 Replies


ADVERTISEMENT

Delete Cell Content If Zero 0

Mar 18, 2008

I need a macro that will search though Column AD and delete the cell contents if the cell contains "0" (zero). Edit: I'm sorry I just figured this out using the following

Dim lastrow, j As Integer
lastrow = Cells(Rows.Count, "ad").End(xlUp).Row
'I presume the last row C is not blank
For j = lastrow To 1 Step -1
'MsgBox j
If Cells(j, "ad") = 0 Or Cells(j, "ad") = "0" Then
Range(Cells(j, "ad"), Cells(j, "ad")).Clear
End If
Next

View 2 Replies View Related

Delete Only Part Of Cell Content

Jul 29, 2006

I got some data like this

CTM
KKB
ACD
TEEE.PK
ACFFE
OO.OB

What i want to do is to delete everything after the dot. And the dot itself

View 4 Replies View Related

Move Cell Content And Delete Source?

Sep 19, 2012

i have code like this to copy certain word in cell and place it at new sheet:

VB:
Sub Foo()Dim i As Long, iMatches As Long
Dim aTokens() As String: aTokens = Split("Accommodation", ",")
For Each cell In Sheets("Sheet1").Range("C:C")

[Code].....

the problem is the cell source is not deleted. what line should i change in code above to move the result to new sheet and delete row source

View 7 Replies View Related

Delete Cell Content But Keep Formula / Lists And The Like

Oct 18, 2013

I recorded a macro:

Code:
Sub Makro4()

Range("A4:C15").Select
Selection.ClearContents

[Code] ......

This code is working home on my MacBook, but I wonder if you have any suggestions for improvement? I will assign this macro to a button.

View 3 Replies View Related

Macro To Delete Specific Cell Content

Apr 24, 2009

I am having some trouble writing a macro to delete cell content. I know which cells I want to clear, but I can't seem to get the macro to do it.

I also want to have something in the macro that inserts data into the lines that I am trying to clear. I want cell A67 to say "Payment" and cell A71 to say "Total."This is the code I am using:
Sub DeleteCell()
Dim i As Integer
For i = 67 To 71
If Range("A" & i).Value = "--" Then
Range("A" & i).Delete
Next i
End Sub

View 9 Replies View Related

VBA To Delete Cell Content With Spisific Data

Jun 19, 2009

I need a VBA that i will attach to a button that will delete spisific data in the cell.

Eg... delete all the cell CONTENT in column A1:A65536 with the word "NONE" in them, it must only delete the word not the cell.

View 9 Replies View Related

If X Number Of Words In Cell, Delete Cell Content, Else Do Nothing

May 26, 2009

This formula counts the number of spaces between words in a cell:

View 5 Replies View Related

Read Cell Content & ADD Content + Font Properties *SOLVE

Sep 12, 2007

I use this to read cell content, add some text/characters (ie. [ and ]) and change the properties of the complete cell

Sub COMMENT()
Worksheets("DVD Lijssie").Activate
If ActiveCell.Value 0 Then ' Change all in to ... ... ...
ActiveCell.FormulaR1C1 = ActiveCell.Value & " " & "]" & " " & "["
With ActiveCell.Font
.Name = "Arial Narrow"
.Size = 8
.ColorIndex = 16
End With
End If
End Sub
HOW can I change this vba-code so it leave's the content of the cell like it is and add some content with the use of let's say TexBox1 and ONLY use different font properties for the newely added content?

View 9 Replies View Related

Change Content Of One Cell Based On Content Of Another

Apr 18, 2014

Formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).

View 4 Replies View Related

Delete All Content Except For Some Words

Jan 24, 2010

I have a column containing mixed text and I want to remove everything from the column except instances of certain colors; black, red, blue etc. Is there a formula which would do this or can it be done with Search/Replace?

View 9 Replies View Related

Delete Rows Based On Content

Jan 5, 2009

Can a macro be used to:

1. Delete rows that contain certain text in a worksheet ?
2. Highlight a cell a colur based on a response ?

I have attached an example of what i mean .....

In the Audit Protocol worksheet is the main information - which contains questions and answers .... If a yes, n/a or no is selected then a response is automatically generated in the observations column (thanks to SHG for helping me with the formula for this) ..... How do I then get the cell to change to red if a NO response only is selected ?

Then the information from the Audit Protocol worksheet (the observation column and number column) are copied across to the worksheet named Action List (this is done just by the copy function) .... How do I go about deleting rows that contain "no action required" - as these are not needed for the report to be generated ?

View 11 Replies View Related

Delete Cells Content If Criteria Not Met

Nov 23, 2007

I have a long list that has all the services from our stores. I´m using the formula below to count how many services does each store have that are over 20 days old.

=SUMPRODUCT((G!$A$2:$A$6000=$B4)*(NOT(G!$I$2:$I$6000="Valmis/Odottaa nouto"))*(NOT(G!$I$2:$I$6000="Valmis, toimitettu"))*(NOT(G!$I$2:$I$6000="Finished/WaitingDeli"))*(Päivämääärät!$C$1-G!$C$2:$C$6000>Päivämääärät!$I$3))

Now i´m wondering is it possible to make a macro that would delete all the cells in the range that do not match the criteria of my formula?

With one exception in sheet G cell A2--> has the number of the store. There are over 40 stores so each store has a number 10, 20, 30, etc...
This is the part of the formula that determines witch store it is counting
(G!$A$2:$A$6000=$B4) B4=10 in this case and B5 would be 20 and so on... By modifying that one part i can count old services for all of our stores.

Now I want the macro to delete all services from the list that are not over 20 days old and belong to the store 10 (B4). If it would delete everything that dont match that formulas criteria i could not get a list of old services for our other stores.

What i´m trying to accomplish is get a list of the services that are over 20 days old. I´m now picking them from the list by hand and that takes a really long time. Because of the number of the stores and the size of the range.

View 9 Replies View Related

DELETE Row Based On Content Of Column

Jan 8, 2008

Need macro or other code that will examine a column in my my table for particular text (example: find text: "Total") and then DELETE the whole row that the cell containing the text is in.

View 9 Replies View Related

Delete Cells Based On Content

Feb 3, 2010

I have this:

Sub CompileData()

'Dim rng1 As Range
'Dim rng2 As Range

'Set rng1 = Worksheets("Sheet2").Range("A4").End(xlDown)
'Set rng2 = Worksheets("Sheet2").Range("C4").End(xlDown)
'Set AllRng = Union(Range("rng1"), Range("rng2"))
'Worksheets("Sheet1").Range("A5").End(xlDown).Delete

Now when its pasted it has cells with "Nil" in it. I need to delete them, or just not copy them over.

View 9 Replies View Related

Delete Content Form Selected Cells

Apr 15, 2014

i have data from D2:D10000

I Used data of first five rows e.g ("d2:d6") if in range ("d2:d6") any cell is blank then delete the all contents of the rows

e.g
d2 have data
d3 have data
d4, d5, d6 have no data then the contents of range ("d4:d6") should delete

View 3 Replies View Related

Delete Content Only Of Every 5th Row - Do Not Want To Delete Row

May 31, 2013

I would like to delete the content only of every 5th row - I do not want to delete the row.

I have about 6000 4 line addresses in one column and between each address is the number 0. Need only to delete the 0.

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

Matrix - Identify Cell Content In Column For Row If Matrix Content True?

Mar 21, 2014

For a table like the one below produced for the sake of example (actual is much much bigger) I want to make it list rows that are true for a certain column for a certain variable in the matrix. So for say water terrain, which types of activity can I do i.e. swimming. Or for Offroad the activites which I can't do i.e. Run and Swim.

ActivityWaterRoadOffroad
Jog nym
Run nyn
Walk nyy
Swim ynn
y=yes
n=no
m=maybe

View 10 Replies View Related

Excel 2007 :: VBA Code To Delete Rows Based On Text Starting Content

Oct 25, 2013

Using excel 2007. I am interested in writing a VBA code to delete rows based on the text starting content. I would like to delete rows with cells that do NOT start with an "S" or "SA"

EX:

05S0128
06S0112
05S2298
S25852
S36963
SA36185

I would only like to keep the last 3 lines.

View 3 Replies View Related

VBA / Word Picture Content Control Causing Unreadable Content?

Jan 15, 2013

I am using VBA to create a word document (.docx). This word document contains plain text content controls as well as picture content controls. I then use VBA to automatically select a picture based on the code below

Code:
Set oCC = Word.ActiveDocument.SelectContentControlsByTitle("TabPic").Item(1)
On Error GoTo TabErrorHandler
oCC.Range.InlineShapes.AddPicture Filename:="X:XFERANDREW-TDCD " & LblVL &

[Code].....

After the document has been closed down I try to open it again and I am told "The file cannot be opened because there are problems with the contents."

When I click details it says "Unspecified error" and "Location: Part: /word/document.xml, Line: 2, Column: 0"

If I click ok it says "Word found unreadable content in "". Do you want to recover the contents of this document? If you turst the source of this document, click Yes.

Clicking Yes opens the document with all the contents and it is now renamed to Document 1. If I click no it does not open.

View 9 Replies View Related

Merge The Content Of 2 Cells Into 1 (with A Comma Separating The Content)

Jan 29, 2007

how to combine the content of 2 cells into one cell and have the information separated by a comma.

For example:

CELL 1:
Software 1

CELL 2:
Spreadsheet Software

The desired results is:

CELL 3:
Software 1, Spreadsheet Software

View 3 Replies View Related

Add Cell Content Into Formula Command In Another Cell For Multiple Files Search

Apr 12, 2014

How to determine the correct formula for this requirement?

Assuming I have 2 individual excel files and an index excel file (in reality, there are more than hundreds of file). For index excel, once the user enter part number (eg. 1 or 2), the excel will look for the part number excel file and determine vlookup function.

The only problem I have here is I can not make the index file automatically add the part number shown on most left column into the required formula (replace the part number file section).

I tried use the indirect function but this require each file to be opened, which is not possible for actual use. I am looking for a function that can work in closed worksheet.

Attached files :
index.xlsx‎
1.xlsx‎
2.xlsx‎

View 2 Replies View Related

Modify Cell Background Color Based On Cell Content

Jul 1, 2014

I am working on developing QR Codes using some MATLAB code and it would be really convenient if I could create an excel program which changed the background color of a cell containing a 1 to black and a cell containing a 0 to white.

View 2 Replies View Related

Using A Formula To Populate A Cell With Certain Data Based On Content Of Another Cell?

Jul 7, 2014

I am currently trying to create a spreadsheet whereby if I enter certain text in a cell in Column A on worksheet 1 that correlates with text in a cell in Column A on Worksheet 2, then the description in Column B in Worksheet 2 is entered into Column B on worksheet 1.

For example, if worksheet 2 has the following:

Column A Column B
XXXX PRODUCT 1
YYYY PRODUCT 2

and I enter XXXX in column A on worksheet 1, I want Column B on worksheet 1 to automatically enter PRODUCT 1.

View 5 Replies View Related

Multiple Find And Replace Cell Content Based On Another Cell?

Mar 25, 2014

multiple search match and replace content in a different column so for example

new workbook (look up table)
sku
search1
search2

[Code]....

so something like where you compare two tables and find and replace based on another cell that matches in my sku.. more details would be if the table column aren't exactly matching but the column header and the row header would match and fill or replace in the correct/corresponding cell is there a macro or vba to do this job in excel?

View 6 Replies View Related

Inserting Values In Cell Depending On Content In Adjacent Cell

Mar 20, 2014

I have the names of companies in one column, and the amount they owe in cells in the column beside them. I then have a second list of companies that is a subset of the first. Is there a formula that would place the amount they owe in teh corresponding cell adjacent to the compny in the second list? I've attached a sample workbook, Full Company List in column A, amount owing in B, trimmed down list in D and ideally I'd like the corresponding values in E.

View 3 Replies View Related

Copy Cell Content Into Next Available Blank Cell In Sheet2?

Nov 26, 2013

I have 2 worksheets, let's call them "Sheet1" and "sheet2".

Sheet 1 has 2 columns (A, and B)

Ie. "Sheet1:"

Col A, Col B

Red
Green Yes
Blue
Yellow
Orange Yes

For each entry in Column "B" that has a "Yes" value, I need to copy the color value in column "A" into the next available empty cell in "Sheet2" in column A.

"Sheet2"

Col A, Col B

Red 3
Blue 5
Yellow 6

Final Result:

Col A, Col B

Red 3
Blue 5
Yellow 6
Green
Orange

how to do this particular challenge? For Sheet2, I think I'll need a function to determine the first available blank cell in column A.

View 8 Replies View Related

Changing Cell Colours Depending On Cell Content

Nov 19, 2008

What I need to do is have a cell that will be say yellow until there is information put into this cell. The information could be in the format of text or numbers. The information would not always be the same so it would need to be yellow when there is no information in the cell and another colour or white when there is information in the cell.

View 6 Replies View Related

Deleting Cell Content Based On Entry In One Cell?

Mar 22, 2014

I have a sheet that I fill out with customer data then print and start over with the next customer. This requires me to tab and delete through the sheet before starting the next entry and I am wondering if there is some way to auto clear the unlocked cells based on a single entry IE when we entered new data in the 1st field this would clear the unlocked cells and make them ready for new data?

View 14 Replies View Related







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