Moving rows of data based on validation

  • Thread starter Thread starter Ylime
  • Start date Start date
Y

Ylime

Does anyone know how I would create a macro that would move a row o
data to a different worksheet based on the validation information of
cell?

For instance, I am working with pending cases. I’d like to have al
open cases on one sheet and when they close, I would choose ‘Closed’ i
my validation cell and would then like that row of data to automaticall
be moved to the Closed worksheet. And then I would like for tha
worksheet to automatically sort based on the criteria we decide on (i
Alphabetically or Chronologically, etc.)

Any help
 
You may find something close at:

http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

or maybe Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top