Help with Formula

S

sclark

I am hoping someone can help me with a formula...I would like to have
sheets in one workbook. On page one will be a master list of returne
packages I get. One column on this 1st sheet will be to mark eac
record as one of 2 types of returns. I would like to know if there i
a way to make excel place each record onto the other sheets accordin
to which type of return it is?

Example - Sheet 1 is all records (A and B's mixed in together)

As I fill in each row with info...say row one was an A, and 2 was a
Can I make Excel automatically transfer all the data in th
correspondiong row to either Sheet one (only A's) or sheet two (onl
B's)


Any help would be much appreciated!!
 
D

Dave Peterson

I think you'd need a macro to do this--and for my money, it ain't worth the
potential problems.

I like to keep all my data together and then use Data|Filter|autofilter to see
just what I want.

It makes generating charts/pivottables for summaries much easier.

But if you really, really want, I'd do all the data entry (for validation
purposes) then move stuff.

You could steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

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

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