Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from tab to tab using a macro
I would like to create a macro that grabs all records with the same State and
pastes them to a new tab with that State name. Any suggestions would be great! Thank you, Sandy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from tab to tab using a macro
Hi Sandy
See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Sandybam" wrote in message ... I would like to create a macro that grabs all records with the same State and pastes them to a new tab with that State name. Any suggestions would be great! Thank you, Sandy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from tab to tab using a macro
Hi Sandy,
Consider using Excel's Advanced Filter option, selecting the 'Copy to another location option. Note that if data is to be copied to another sheet, the filter should be run from the destination sheet. If you need to automate the process, turn on the macro recorder while you perform the required steps. The resultant code may be edited to enable more general application. If you experience problems with such editing, post back with the problematic code. --- Regards, Norman "Sandybam" wrote in message ... I would like to create a macro that grabs all records with the same State and pastes them to a new tab with that State name. Any suggestions would be great! Thank you, Sandy |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from tab to tab using a macro
http://www.rondebruin.nl/copy5.htm
at Ron de Bruin's site has sample code related to this. -- Regards, Tom Ogilvy "Sandybam" wrote: I would like to create a macro that grabs all records with the same State and pastes them to a new tab with that State name. Any suggestions would be great! Thank you, Sandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to move data from one sheet to another | Excel Discussion (Misc queries) | |||
Move data Macro | Excel Discussion (Misc queries) | |||
Macro to move data to different column based on data in another co | Excel Discussion (Misc queries) | |||
enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
create macro to move label type data to column data | Excel Programming |