PDA

View Full Version : VBA Code to Auto-Select Rows and Copy to New Worksheet



PCC2007
01-08-2007, 08:29 PM
I need to be able to create VBA code to select all rows within a worksheet that have a particular text value showing in Column A for that row; there will be only 3 values of interest in Column A (Sold, Active or Pending).

Each row showing the value of interest in Column A will then need to be copied to a new worksheet (3 new worksheets) labeled with the value that was used to sort for the worksheet.

I expect that the original worksheet will have no more than 1,000 rows.

I a newbie with VBA coding.

Thanks!

lucas
01-08-2007, 09:17 PM
From the knowledgebase:
Multi Filtered search and create (http://vbaexpress.com/kb/getarticle.php?kb_id=787)

by gibbo1715

PCC2007
01-09-2007, 06:55 AM
Thanks for the quick reply! I'll need to use the code to make sure I understand how it all works. I may want to automate even further so that the user will not even need to enter the criteria or the column that contains the criteria. I'm not sure how to approach that one quite yet...