Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy info from worksheet 1 to other sheets
I have a file with 4 columns in sheet1. Name-Town-Job-Type. There are 4
possible entries for "Town". If the town entry in sheet one is "X", I want that entire row to be copied to sheet2, If"Y" to sheet 3. If "z" to sheet4. If "ZZ" to sheet 5. Can this be done? Any help appreciated -- John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy answer to another worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |