| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Create a 3rd sheet containing cells in both Sheets 1 and 2
I have 2 sheets. They both contain a list of Account Numbers. What I want to
do is to have a 3rd sheet created containing only those account numbers that are found in both Sheet 1 and Sheet 2. For example: Sheet 1 Account Numbers AAAAA BBBBB CCCCC DDDDD EEEEE FFFFFF 9999999 GGGGGG HHHHHH IIIIIII JJJJJJ KKKKKK LLLLLLL 333333 444444 Sheet 2 Account Numbers 1111111 KKKKKKK 222222 EEEEEEE 999999 XXXXXXX TTTTTTTT AAAAAA FFFFFFFF Sheet 3 AAAAAAA EEEEEEEE FFFFFFF 9999999 KKKKKKKK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
| copying text on sheet 1 to corresponding cells on sheets 2 to 5 | New Users to Excel | |||
| Create summary sheet of last row of info from other sheets | Excel Worksheet Functions | |||
| How do I create a formula using cells from two different sheets? | Excel Worksheet Functions | |||
| Create a single sheet from many sheets | Excel Worksheet Functions | |||
Threaded Mode
