Search : in
By :

Delete Rows Based on a Count Criteria

Mike, on Mar 12, 2009 3:55:16 pm GMT 
 Report this message to moderators

Hello,

I need help with a macro that will delete a specific number of rows based on a hard key entry in a cell.

Say I have 300 employees that work in Administration but I need to layoff 5 employees with a specific job classification. Is there a way that I could enter the department, job classification, and number of employees to lay off, then run a macro that deletes those (number) of employees?

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Delete Rows Based on a Count Criteria » in :
Copy rows based on a condition Show Copy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I've tried almost everything but...
[Sed] Delete one or more lines from a file Show[Sed] Delete one or more lines from a file Removing one (or several) line (s) of a file Syntax: sed '{[/]||[/]}d' sed '{[/][,][/]d' /.../=delimiters n = line number...
How to restore deleted files ShowHow to restore deleted files Download a recovery tool There are easy and effective recovery tools available for download on the web and some have the major advantage of being free. Zero Assumption Recovery Download Link: http://www.z-a...
Basic MS-Dos commands ShowBasic MS-Dos commands Intro The command prompts: Intro Here is a list of basic commands that you can use in a DOS prompt (e.g. a using a boot disk). To have additional information about these commands, type /? after entering the...
UNIX Commands ShowTable of the main UNIX commands Unix Commands Description Options ls lists the content of a directory -a Displays all files, including hidden files -I Displays a...