Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-23-2017, 07:15 AM
gebobs gebobs is offline Excel 2016 Filter Help Windows 7 64bit Excel 2016 Filter Help Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Rather than change the data in the original column, copy the data to another column that you will use to edit. Thus you will have something like:

JLN:TRANSFER JLN:TRANSFER

which you will edit to be:

JLN:TRANSFER Transfer to John Smith

Thus you will still be able to filter the original data.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2016 Filter Help how to filter column by last working day in excel AC PORTA VIA Excel Programming 17 02-20-2017 06:07 PM
Excel 2016 Filter Help Ms Excel 2016 IF function IFnoob Excel 1 08-13-2016 11:34 PM
Excel 2016 Filter Help =filter() feature of google sheets not in EXCEL peter.threepins Excel 1 07-13-2016 08:44 AM
Excel 2016 Filter Help Filter Mail Merge based on a list of filter criteria AusSteelMan Mail Merge 2 05-09-2016 03:35 PM
Excel 2016 Filter Help unusual bug in excel 2016 roger_27 Excel 1 04-01-2016 05:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:16 AM.


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