Copying Rows dependent upon a given cell value

[Guest]

I have a spreadsheet which lists documents in a single master list.

These documents are graded on for levels "level1", "level2", "level3",
"level4", (I was up all night thinking of that one)

I want to seperate the documents on additional sheets, titled as above, to
enable the user to look at the specific levels.

I also want to keep the conditional formatting applied in the master list as
it is copied across to the different levels. Hence, any editing on the
master list will be copied onto the 'sub lists'. Previous attempts to do
this have resulted in big gaps in the sub lists

what do I need to do to ensure that the sublists do not have empty lines and
I can retain the formatting etc in the master list.

I've a feeling it's an 'IF' statement but haven't a clue where to start.

It's probably straightforward to you people but I'm afraid I'm floundering
here.

Feel free to ask any questions as I may not have explained myself
particularly well

Terry

 

[Dave Peterson]

Your life will be much easier if you keep all your data on one worksheet.

You could apply Data|Filter|Autofilter to see/hide any subset of your data.

But if you really want (I wouldn't do it!)...

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

This will not result in automatic updates between sheets. But you can recreate
those sheets whenever you want (after you update the master sheet).