PC Review


Reply
Thread Tools Rate Thread

Cut filtered rows, paste into next empty row of new sheet, and delete cut rows

 
 
Scott
Guest
Posts: n/a
 
      13th Dec 2006
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hpw do I delete multiple empty rows found between filled rows? Bill Microsoft Excel Worksheet Functions 1 15th Nov 2009 12:52 AM
How to Delete empty rows in excel in b/w rows with values =?Utf-8?B?RGVubmlz?= Microsoft Excel Worksheet Functions 3 28th Aug 2007 04:15 PM
Delete empty rows from a sheet bm4466 Microsoft Excel Programming 2 5th Jun 2006 03:59 PM
delete empty rows of a sheet p. panter Microsoft Excel Programming 5 18th Feb 2006 03:17 PM
Cut and Paste macro based on criteria then delete empty rows samst Microsoft Excel Programming 4 2nd Nov 2003 09:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:13 AM.