![]() |
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows
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. |
All times are GMT +1. The time now is 04:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com