Thread
:
Macro for deleting rows and serialising the remaing rows
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Macro for deleting rows and serialising the remaing rows
See answers in your OTHER post. It is frowned upon to post in more than one
group.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Srinivasulu Bhattaram" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett