Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating New Worksheets for identical cells
Hello, I need help with the following. I have a master report of all company employees. Example of the report is: Reg Dist Store EE# Name REG03 007 0034 12345 JOHN DOE REG03 007 0035 12345 JOE DOE REG03 007 0040 12345 JOY DOE REG07 010 0407 54321 JANE DOE REG09 059 0320 67890 JILL DOE REG03 087 0542 9876 JACK DOE What I would like to do is have something, Macro/VBA/anything identify all like cells in Dist and transfer those cells onto a new worksheet. So now I'll have a worksheet that has only information for 007, 010, 059, and 087. If anyone has any ideas, I'd be happy to hear them. -- bhussey ------------------------------------------------------------------------ bhussey's Profile: http://www.excelforum.com/member.php...o&userid=31244 View this thread: http://www.excelforum.com/showthread...hreadid=509169 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identical Cells in Multiple Worksheets in one Workbook. | Excel Worksheet Functions | |||
How do I compare two worksheets to see if they're identical? | Excel Discussion (Misc queries) | |||
How do I match identical data from two different worksheets in one | New Users to Excel | |||
Protection of identical cells on multiple worksheets | Excel Worksheet Functions | |||
Tracking changed cells in two identical worksheets | Excel Programming |