delete a cell

Good morning everyone, I am working with a rather larger dataset of a single column of calculated values. These values each have 3 blank cells in between each entry. The column in its entirety (including the blank cells) is roughly 100,000 lines long. I am attempting to select all blank cells...

Good morning Everyone, I have been asked of what seems like a simple task but is complex when talking about possibly 100k+ instances. The issue: The data currently has mistakes and the mistakes have been identified and could be seen here -...

i have no clue to doing this man, i expect the output is to be the right chart, but on the left chart is what i’ve done i want the cell to still remain the same number even the row is deleted and if i add new no. it still going +1 i need your help guys

I know that the worksheet_change event is fired when a cell is deleted. Can I store the address of that cell that was just deleted to use it to then delete the same cell reference in other sheets? For example if I delete A3 on Sheet1, can I then select A3 on Sheet 2 and Sheet 3 and delete it on...

Hi All, I'm a beginner in terms of VBA and so I need help in finding duplicate data in columns then automatically deletes or selects them for deletion. Here's a macro VBA code I found on the internet but it only displays the word "duplicate" in another column. - Sub sbFindDuplicatesInColumn()...

I am fairly new to Excel. I need to create cells where anyone can enter data into a blank cell but not be able to delete the data once entered. Ideally the only function I would like is to allow the user to be able to perform a strike through once data is entered.

I would like to write a vba code that if find a row contains "No Data" then delete seven rows to up. <colgroup><col span="7"><col></colgroup><tbody> RSV 134 ATN AT OT Close Name NA DT CRA ADJC ADJ NA No Data Found for selected </tbody> So...

<colgroup><col span="3"><col></colgroup><tbody> A Cloumn` B Column C Column D Column Good 52 1 4/12/2017 0:00 Good 53 1 4/12/2017 0:00 Good 4234 1 4/12/2017 0:00 Good 5232 1 4/12/2017 0:00 Good 42342 1 4/12/2017 0:00 Good 24442 1 3/30/2018 0:00 Bad 41233 0 4/12/2017 0:00...

I have the following data and would like some VBA Code to run down the Rows and based on the number in Column D, Delete the Cells (and Shift Data to the Left) in Columns E to I based on the number in Column D. For example, In Row 1, to delete Cells F1:I1, as the value is 1; Value retained =...

I have the following data and would like some VBA Code to run down the Rows and based on the number in Column D, Delete the Cells (and Shift Data to the Left) in Columns E to I based on the number in Column D. For example, In Row 1, to delete Cells F1:I1, as the value is 1; Value retained =...

Hi all I'm trying to write a macro that will remove duplicate data in a table. Essentially, my table looks like this: <tbody> Applicant Name Personal Statement Work History Education History Applicant1 Applicant1_PS Applicant1_WH1 Applicant1_EH1 Applicant1 Applicant1_PS Applicant1_WH1...

I have found this code from another thread on this forum for deleting the row that contains a cell (in column B) that begins with a specific letter. I would like to perform the same task for numbers. Simply replacing the C* with 2* has not worked. Any help is greatly appreciated. Sub...