macro to copy specific rows to a new book

  • Thread starter Thread starter Karen W
  • Start date Start date
K

Karen W

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Specific Rows in Range and Create New Tab 18
Extracting rows based on value in first row 2
Macro 1
how to write a macro to club data in multiple excel workbooks into asignle one??? 1
from pivot table to vb array copy to new table 3
copy by timevalue to last row 3
Import Data from SQL server to excel 0
Specific Macros 5

Back
Top