If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Moving certain data to different sheet
This can definitely not be created with a formula. I suggest that you make
use of the macros. Rgrds, Kristiina -- I help with Excel and PowerPoint Office ToDo http://www.officetodo.com |
#3
|
|||
|
|||
Moving certain data to different sheet
Try a macro.
See Ron de Bruin's site for code. http://www.rondebruin.nl/copy5.htm Also have a look at downloading Ron's EasyFilter add-in. http://www.rondebruin.nl/easyfilter.htm Gord Dibben MS Excel MVP On Fri, 7 May 2010 10:24:02 -0700, mailrail wrote: 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 | |
Display Modes | |
|
|