Macro for deleting rows and serialising the remaing rows

  • Thread starter Srinivasulu Bhattaram
  • Start date
S

Srinivasulu Bhattaram

Macro for deleting rows and serialising the remaing rows
====================================================

I have a spread sheet

It's a ToDo List



The structure is like this

Column A Sl No

Column B Task

Column C Person

Column D Completed



To start with I keep entering the tasks in one stretch and take a print out.

The first Column (A) will be a serialized.

I wil be using this print out for few days.

After two/three days, I would like to open the spread sheet and enter fresh
tasks

For all completed tasks I put x in Col D.

What I currently require is a macro to



1.. Remove all rows where Column D contains 'x" (quotes not included.)
2.. After this operation, contents of Column A will have to be serialsed.


seena




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 081111-0, 11/11/2008
Tested on: 11/12/2008 6:00:31 PM
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com
 
D

Don Guillett

See answers in your OTHER post. It is frowned upon to post in more than one
group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for deleting rows and serialising the remaing rows 1
Macro for deleting rows and serialising the remaing rows 1
Macro for deleting rows and serialising the remaing rows 2
SPOOFED 2
Macro Formula for counting rows and doing a fill in afterwards 0
Deleting blank cells w/o impacting other rows/columns 5
MACRO THAT CUT ROWS BETWEEN SHEETS AND ADD EMPTY ROWS 0
Macro for removing specific rows and columns, freezing panes..? 3

Top