#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
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.
|
#3
|
||||
|
||||
__________________
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 |
#4
|
|||
|
|||
Quote:
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 |
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 |
Table rows moving to new page when you don't want them to | graham | Word Tables | 1 | 11-16-2009 08:51 AM |