entire

Hi! I would really appreciate help in building a code that would : In Sheet 1, if any cells in Column E contains the word "Done" it would cut Column C of that row to the last column with data in the same row Paste the entire row that was cut as values into the next free row in Sheet 2 Then...

Hello, I have a list of data in which I would like to delete the entire row if the text on column A is in lowercase. I am stuck to write a VBA for this one, could anyone help me with this please. Thank you.

Im having a runtime error on my code below. can someone please help me. Thank you very much. Private Sub CmdDelete_Click() 'find the row Set findvalue = DataSH.Range("B:B").Find(What:=Me.Emp1.Value, _ LookIn:=xlValues, LookAt:=xlWhole) 'delete the entire row Set Addme =...

I don't know if this is even possible, but if it is and someone knows how to do it, I sure would like that knowledge. I have a workbook that is being treated as a controlled document. I need to protect the entire sheet from format changes. However, at the same time, I need to be able to have...

I would like to prompt the macro to ask for a column number and then enter the following formula in the cell from row 2 onward until the last data in the column: =IF(A2="","Unique",IF(COUNTIF($A$2:$A$1000,A2)>0,"Match","Unique")). I want to populate the entire column where the data ends with the...

Hello everybody. I'm struggling with this job: for each cell in a column, I have to check if the letter "I" is contained. If yes, clear the entire row. Now, with the following code something is wrong (all rows are cleared, also if "I" is not contained). If InStr(1, cell, “I”) > 0.5 Then...

Using conditional formatting, I'm looking to highlight all blank cells in column G, if the corresponding cell in column F = Closed-Lost. Using the formula =AND(ISBLANK(G1),F1="Closed-Lost") I can get this to work for the first row but can't get to to work for the entire columns (G and F). I've...

Hi Excel Wizards, Right now once a drop down value is selected (ans), a time stamp is added to H and the entire row is copied to another sheet (ans) corresponding with the drop down. Here is a shorten version of what I have, with one example using the value TEST. Private Sub...

Hi there, I need the following VBA Codes: 1) I need a nice button to on tab named "Control" with the following VBA code to achieve the following: Go to: "AAA" tab and clear the contents (keep formats) from A2:C1000 I want to acheive this without the screen flickering and would like it to...

Is there a way,using VBA, to clear E3 & below (the entire column) except the header at A2 ?

Hi Mr Excel Fans, can you kindly help me with this code below: it will not delete the entire row when Column U contains data called "FREE", how ever it will change the colour of it ' Will not delete the entire row if data matched in column U For i = 6 To LastRowFind If...

I'm having trouble with the below not deleting the entire row. For Each cel In Range("L1", Range("L" & Rows.Count).End(xlUp)) If Left(cel.Value, 1) <> 8 Then cel.EntireRow.Delete End If Next

How do I share one individual worksheet rather than the entire workbook? I often have to share one worksheet of a large workbook with a coworker. Right now, I copy the one worksheet and save it in its own workbook but was wondering if there was an easier way.

Hi, This is the last piece of code that I need to make this project work. Please, Please can someone help? I have been working on this entire code project for about a month now and just need this to complete it. I need this in VBA. This is a sample of the worksheet i am working on...

Hello, So I have this list of information which you can see below: In this chart I have a list of players (A - S), what their respective strength is, and the time they are able to cover in the time range 0 - 24. I am trying to figure out if there is a way to get excel (whether through a...

I can find a lot of solutions that will highlight the first incidence of a given value in each column but I am looking for a version that will only highlight one incidence in the entire array. The current version is as follows (array is B2:FQ450) =COUNTIF($B$2:B2,B2)=1

Hello all, Good day. I have excel file in the below format. Excel 2013/2016ABCDEFGHIJKLMNO81280240419405-B21OZJ8283SAP-Doc-No :Customerno. (CLE):84SA ID :Customername :85Groupingno :8687ItemNrHiLeItMaterial...

Hello all, Good day. In c drive i have 1 excel file. Excel file Name : "acd.xls" I Need to open and delete entire row. Condtion : AA row contain "ZR" i need to delete entire row . save the excel and close the excel. Please help/.

Hi, I have a sheet that I need to copy dozens of times. This sheet (let's call it MasterSheet) has named ranges that are not for the entire workbook but only for itself in order to succefully reproduce the Mastersheet: I named for example "StartPause1" the cell B4, so that from now on each...

Hello, I need to delete columns that have "'-" in the entire columns. If I filter that it will only shoe "-" in the drop down. I needed to delete all the columns that have those values in cells. I tried searching but could not come up with any.. There are multiple columns that have these...