Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2018, 01:29 PM
MJD MJD is offline Query a word in a Excel Spreadsheet. Mac OS X Query a word in a Excel Spreadsheet. Office 2016 for Mac
Novice
Query a word in a Excel Spreadsheet.
 
Join Date: Jan 2018
Posts: 1
MJD is on a distinguished road
Default Query a word in a Excel Spreadsheet.

I have a spreadsheet that keeps record of my personal library. I have app 3000 volumes. I have columns such as: Title, Author, Subject, Publisher, etc.



What I would like to do is to identify all the books that have the same subject and word in their title and create a new folder?

I can Identify them in the search feature, but how do I move them and only them to a new "sheet"?
Reply With Quote
  #2  
Old 01-18-2018, 12:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Query a word in a Excel Spreadsheet. Windows 7 64bit Query a word in a Excel Spreadsheet. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi
perhaps use a filter?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
query



Similar Threads
Thread Thread Starter Forum Replies Last Post
Query a word in a Excel Spreadsheet. Word Doc Update from Excel Spreadsheet jmattingly85 Word VBA 4 08-09-2017 10:13 PM
Query and Power Query not working Excel 2016 bl10 Excel 0 07-22-2016 06:25 PM
Query a word in a Excel Spreadsheet. Creating a list in Word from an Excel spreadsheet gingernut Mail Merge 1 03-19-2013 02:12 PM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? mag Excel 0 10-18-2012 11:15 AM
Query a word in a Excel Spreadsheet. Inserting excel spreadsheet into word doc educpara58 Excel 2 07-28-2011 01:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:56 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