(Msg. 1) Posted: Wed Nov 12, 2008 5:59 pm
Post subject: Macro for deleting rows and serialising the remaing rows Archived from groups: microsoft>public>excel>printing (more info?)
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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office