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
Novice
Moving rows to new tabs
 
Join Date: Nov 2021
Posts: 17
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: 713
ArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to behold
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,585
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
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
Competent Performer
 
Join Date: May 2019
Posts: 131
kilroyscarnival is on a distinguished road
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 11:02 AM.


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