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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com