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!
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!