Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-16-2023, 12:20 PM
Sportsmen Sportsmen is offline Copying column to another column with deleting date due to blank cells Windows 10 Copying column to another column with deleting date due to blank cells Office 2019
Novice
Copying column to another column with deleting date due to blank cells
 
Join Date: Nov 2022
Posts: 8
Sportsmen is on a distinguished road
Default Copying column to another column with deleting date due to blank cells


So I have 2 columns. I want to cut all the data from column H/Local and paste it into G/rating. However, I do not want the blanks from column H to delete data in G. I could alt and click on the cells in this example, but I need to be bale to do this with thousands of cells so I was hoping to figure out an easier way.

Thanks again for the help!

The 2nd I post on here I figure it out. Sorry for bothering you guys.
Attached Files
File Type: xlsx test ex.xlsx (9.7 KB, 3 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying column to another column with deleting date due to blank cells Select all cells in a column , even when blank... Chayes Excel Programming 4 05-30-2018 10:35 AM
Copying column to another column with deleting date due to blank cells Vlookup fill down blank cells in column mbesspiata Excel Programming 8 09-26-2016 04:44 AM
Auto Fill only Blank Cells in a Column mbesspiata3 Excel Programming 1 09-22-2016 07:18 PM
Copying column to another column with deleting date due to blank cells Copying DNA from web and need to convert column date to ex: 11-15 JacMUr2 Excel 2 01-22-2016 03:36 AM
Return Sum value of one column from cells not blank in another column zulugandalf Excel 3 08-14-2014 03:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:23 PM.


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