Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving certain data to different sheet
I need to move data that meets a certain criteria, to another sheet within a
workbook. For instance, if a column of data is for a certain ZIP code area, I need it to automatically copy to a sheet for that city. Say, 40202 would go to the Louisville, KY sheet. Because Louisville has multiple ZIPs, I would need only the data that begins with 402 to go to that sheet. Lexington KY's data, which begins with ZIP code 405, would go to its own sheet. Macro? Formula? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving data from one sheet to another | Excel Discussion (Misc queries) | |||
Moving data from one sheet to another | Excel Discussion (Misc queries) | |||
moving data from one sheet to another | New Users to Excel | |||
moving data from one sheet to another | Excel Discussion (Misc queries) | |||
Moving data from one sheet to another- How to? | Excel Worksheet Functions |