Can I auto move a row to the next worksheet if criteria is met

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a spreadsheet for results of various tests on aproduct, is
there a way I can automatically move a row to sheet 2 if a certain criteria
is met, for instance if a cell at the end of the row says "Fail". I don't
want to have to go through manually and copy and paste this info. Can anyone
help ??
 
You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
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

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
You must log in or register to reply here.

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

Delete rows but keep formatting to 1000 4
Auto Copy Data from one worksheet to another 1
Open another workbook if condition met 2
Deleting Values in a Row based on a Certain Criteria 2
move from sheet1 to sheet2 if criteria is met 3
VB to specify criteria then paste to a new worksheet 1
Insert number of rows based on criteria 6
Remove empty rows from a range 3

Back
Top