|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deleting part of a row and move the remaining records in these columns up based on a cell being blan
Hello, I’m using a file written by ArviLaanemets (FillColumnsExample.xlsm) and it is working well. I want to add a macro where if the content of a cell in column C is cleared then cells A, B and D in that row are cleared and all of the records in A,B,C and D below are moved up. I do not want to delete the whole row because of the formulas that are in columns F,G,H and I. I was going to move all the formula cells to another sheet so I could just delete the whole row but it is very convenient having them on the same sheet. |
#2
|
|||
|
|||
Forgot attachment
It seems I attached the file incorrectly. Here it is here.
|
#3
|
|||
|
|||
Just start recording a new macro, then delete cell contents, then click on header to resort table. Done, you can edit the macro in VB from the developer tab.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro for deleting cell contents based on another cells contents | SJCrawley | Excel Programming | 1 | 06-04-2021 01:05 AM |
How to delete unused cell remaining at end of a block of deleted data | SKEETER | Excel | 2 | 10-24-2017 07:06 AM |
Entering a column value in a cell, to be used as part of a reference in a formula in another cell | paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
have part of page with 2 columns | expert4knowledge | Word | 2 | 09-17-2014 11:49 AM |
Deleting records/results from mail merge | alexb123 | Mail Merge | 2 | 08-12-2011 02:27 PM |