Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-04-2022, 02:22 PM
JHalter JHalter is offline Windows 10 Office 2019
Advanced Beginner
Moving rows to new tabs
 
Join Date: Nov 2021
Posts: 46
JHalter is on a distinguished road
Default Moving rows to new tabs


I want to move entire rows to a new tab that contains certain text. How do I set this up without having to copy/paste all the rows containing the certain text?
Reply With Quote
  #2  
Old 08-07-2022, 10:21 PM
ArviLaanemets ArviLaanemets is offline Moving rows to new tabs Windows 8 Moving rows to new tabs Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Create a report sheet instead, which reads and displays data from your original data sheet! As additional bonus, on report sheet you can have one or several fields, where user can enter/select filter conditions for report - so essentially you get different report for every set of conditions.
Reply With Quote
  #3  
Old 08-08-2022, 02:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Moving rows to new tabs Windows 7 64bit Moving rows to new tabs Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Known problem How to Move Row to Another Sheet Based On Cell Value in Excel? - Spreadsheet Planet
__________________
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
  #4  
Old 08-08-2022, 02:37 PM
kilroyscarnival kilroyscarnival is offline Moving rows to new tabs Windows 10 Moving rows to new tabs Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by JHalter View Post
I want to move entire rows to a new tab that contains certain text. How do I set this up without having to copy/paste all the rows containing the certain text?
I think it says you have Excel 2021, so you might have access to the FILTER function.

I got to play with this last year to do the same sort of thing. It pulls info to various tabs based on whether the text in the first column contains a specific letter pertaining to that division of the company. From there I specified which columns to copy and in which order. I'm not sure I used it recently enough to do without looking up the steps, but:

FILTER function
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I stop check boxes moving rows when text wraps in an adjacent cell? PatrickYork Excel 2 04-04-2018 11:23 AM
Moving a row or rows on "yes" from formula bobby@uk Excel Programming 2 12-07-2014 06:41 PM
Moving from Rows to Columns jimmydd2121 Excel 1 06-02-2014 09:05 AM
Moving data from multiple rows to 1 row for each program number ballj_35 Excel 3 08-01-2012 05:10 AM
Moving rows to new tabs Table rows moving to new page when you don't want them to graham Word Tables 1 11-16-2009 08:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:57 PM.


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