I try to keep the data in one location, then apply Data|Filter|autofilter to
that range.

Then I can show/hide the rows I want to see.

But if you really want...

Maybe you could steal some 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


Jay wrote:

I have a series of data on a sheet called "DataEntry", on this sheets data is
entered for 4 shifts (Shift A, B, C, D) listed vertically in column A1:A3000.
These values are a mix and not listed alphbetically (Example A, C, A, B, C,
D, D, C, etc, etc) these go across the sheet 10 - 12 columns wide.

Now, I have other worksheets which represent each of these shifts
respectively; A-Shift, B-Shift, C-Shift, D-Shift. What I'd like to do is grab
(if possible) any data for A shift on the "DataEntry" worksheet in column
A1:A3000 and plug them unto the A-Shift worsheet chronologically entered
without any blank line/records between them, since these would be have been a
mix on the parent/source worksheet.

Is this appraoch even possible? If so, How?

--

Dave Peterson