Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to copy specific rows to a new book
Hello,
I would like to have a macro that would prompt me for a "center number", search an Excel database for that number and copy the rows for that center number into a new book. The center number is always in the first column. The database is always sorted by the center number. It sounds fairly easy, but I'm not familiar enough with VB language to do this. Would someone be willing to help? Thanks so much. Karen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to copy specific rows to a new book
Hi Karin
Code Example http://www.rondebruin.nl/copy5.htm Add-in solution http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Karen W" wrote in message ... Hello, I would like to have a macro that would prompt me for a "center number", search an Excel database for that number and copy the rows for that center number into a new book. The center number is always in the first column. The database is always sorted by the center number. It sounds fairly easy, but I'm not familiar enough with VB language to do this. Would someone be willing to help? Thanks so much. Karen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too Few Rows to copy sheet to another book | Excel Worksheet Functions | |||
Copy / paste only specific rows | Excel Discussion (Misc queries) | |||
COPY AND PASTE SPECIFIC ROWS | Excel Discussion (Misc queries) | |||
Macro to automaticaly save a book under an specific name | Excel Programming | |||
Macro to copy down specific number of rows | Excel Programming |