Automatically transferring rows from a master list to sub lists (in another sheet)

**nicholaslj999** · 11-23-2016, 01:34 PM

Hi I am hoping someone can help...

I have a list of tasks which need to be completed and I have multiple sheets which I manage these with (and the lists are too large to keep managing from multiple sheets).

What I am wanting to do is to have one list (with the same headings for each) and subject to one field it would also show that row on another sheet.

i.e.

Task 1, System Telephony, Issue xxxxx.
Task 2, System CAD, Issue xxxx.
Task3, System Telephony, Issue xxxx.

I would like sheet 1 to show all Telephony system issues and sheet 2 to show all CAD related issues.

Does anyone know how I can do this at all?

**JBeaucaire** · 11-23-2016, 04:50 PM

I would not recommend multiple sheets. You can still get what you want right on the main single sheet.

1) Highlight the row1 headers
2) Turn on the Data > Filter
3) Use the column B drop down to select a single value, like System Telephony

You are now looking at exactly what you would see in a separate sheet, those rows only, all other rows are hidden away. You can edit, print, whatever you were going to do with the separate sheet, but far less plumbing this way.

Filter again for a different value, or show all. Very handy and simple.

Automatically transferring rows from a master list to sub lists (in another sheet)

LinkBack

Thread Tools

Rate This Thread

Display

Automatically transferring rows from a master list to sub lists (in another sheet)

Re: Automatically transferring rows from a master list to sub lists (in another sheet)

Thread Information

Users Browsing this Thread

Similar Threads

Transferring data from master sheet to slave sheets

Adding or deleting rows in master sheet and automatically update target sheet

Automatically transferring a Row of info from Master Sheet

insert/delete rows automatically to other worksheets when altering master list on sheet 1

Excel 2007 : Transferring rows from a master tab using a date criteria to a seperate tab

Help: transferring rows from a master sheet

"master" sheet - that is, generate a list combining all lists

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions