LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default moving rows based on criteria

I would like to move entire rows based on a criteria in one of it's columns.
I would like to be able to bo this several times a day. I want it so it does
not effect the order of the rest of the rows.

example:
if column 20 is shipped and is a date

If column 20 have a value, then move it to worksheet "SHIPPED"

I would like to have this so that I can run a macro, and have it move all
shipped to the shipped folder.
All BACKORDERED (column 21 and is a logical) if set to TRUE, move to
worksheet BACKORDERED
all (based on a value from a dropdown) that equal "AquaCulture" to worksheet
"Aquaculturist"

Thanks
Phil


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving rows with multiple criteria PAL Excel Worksheet Functions 1 July 9th 08 02:49 PM
Moving cells based on certain criteria halvy52 Excel Discussion (Misc queries) 5 April 28th 07 04:01 AM
Moving Rows to another sheet based on an entry Liketoknow Excel Worksheet Functions 0 August 22nd 06 04:50 AM
Moving rows from one sheet to another based on a particular cell v mm Excel Discussion (Misc queries) 0 November 11th 05 06:29 PM
Sum based on criteria in rows and columns EstherJ Excel Discussion (Misc queries) 1 November 1st 05 10:28 AM


All times are GMT +1. The time now is 01:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"