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?
Bookmarks