Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2022, 01:48 PM
14spar15 14spar15 is offline Deleting part of a row and move the remaining records in these columns up based on a cell being blan Windows 7 64bit Deleting part of a row and move the remaining records in these columns up based on a cell being blan Office 2010 64bit
Advanced Beginner
Deleting part of a row and move the remaining records in these columns up based on a cell being blan
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-01-2022, 08:56 PM
14spar15 14spar15 is offline Deleting part of a row and move the remaining records in these columns up based on a cell being blan Windows 7 64bit Deleting part of a row and move the remaining records in these columns up based on a cell being blan Office 2010 64bit
Advanced Beginner
Deleting part of a row and move the remaining records in these columns up based on a cell being blan
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Forgot attachment

It seems I attached the file incorrectly. Here it is here.
Attached Files
File Type: xlsm FillColumnsExample.xlsm (11.1 KB, 8 views)
Reply With Quote
  #3  
Old 11-09-2022, 03:46 PM
trevorc trevorc is offline Deleting part of a row and move the remaining records in these columns up based on a cell being blan Windows 7 32bit Deleting part of a row and move the remaining records in these columns up based on a cell being blan Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Deleting part of a row and move the remaining records in these columns up based on a cell being blan 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 part of a row and move the remaining records in these columns up based on a cell being blan Deleting records/results from mail merge alexb123 Mail Merge 2 08-12-2011 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft