S
Scott
The following is a process for which I'm hoping to create a macro. The
macro will be for a file in which all cells (including numbers) are
formatted as text, to make use of the custom AutoFilter dialog if
needed. I'll try to be as thorough as possible, so let me know if you
need more info. I use the terms "record" and "row" interchangeably in
the description below.
Process A: Transfer filtered records to a new worksheet
1. Find and select all records in a master worksheet whose value in
column B begins with #### or *#### (where #### = a specific 4-digit
number and *#### = any character plus a specific 4-digit number)
2. Copy and paste these records to the next blank row in another
existing worksheet.
3. Delete the copied rows from the master worksheet.
Process B: Add text to cells in a specific column for a filtered list
of records
1. Filter a worksheet for values in 2 or 3 columns
2. Append a specific 1- to 3-character text string plus a space to the
beginning of cells in a specific column for all filtered records.
Any help on either process or any specific step would be greatly
appreciated.
macro will be for a file in which all cells (including numbers) are
formatted as text, to make use of the custom AutoFilter dialog if
needed. I'll try to be as thorough as possible, so let me know if you
need more info. I use the terms "record" and "row" interchangeably in
the description below.
Process A: Transfer filtered records to a new worksheet
1. Find and select all records in a master worksheet whose value in
column B begins with #### or *#### (where #### = a specific 4-digit
number and *#### = any character plus a specific 4-digit number)
2. Copy and paste these records to the next blank row in another
existing worksheet.
3. Delete the copied rows from the master worksheet.
Process B: Add text to cells in a specific column for a filtered list
of records
1. Filter a worksheet for values in 2 or 3 columns
2. Append a specific 1- to 3-character text string plus a space to the
beginning of cells in a specific column for all filtered records.
Any help on either process or any specific step would be greatly
appreciated.