If Info. from one Sheet matches, send it to another sheet

S

Slava

I am trying two link to workbooks. The first workbook contains several
different sheets with different peoples profiles on each sheet. In column C
of each sheet, there is either 'RES' or a 'COM'. The second workbook is
still blank. I would like to break that book up into two seperate sheets
(one for 'RES' and one for 'COM'). If information in column C on the first
spreadsheet is 'RES', I would like ALL the information in that Row to go to
the second Workbook designated for 'RES' and vice versa! Is this possible?
 
D

Dave Peterson

First, I think it's a mistake to separate your data. As soon as I do this, I
have problems keeping the data in sync.

But if you want, you could apply Data|Filter|Autofilter to that column. Filter
to show RES and then copy those visible cells to the new RES sheet. Then filter
to show COM and do the same.

You'll have to do this for each sheet.

If you need a macro, you can record one when you do it the first time.

==
I think I'd try to put all the data onto just one sheet. (Maybe adding a key
column if required.) Then just use Data|Filter|autofilter to show/hide the data
I need to see.
 
Top