Dynamic copying of data to new sheets

  • Thread starter Thread starter quirthanon
  • Start date Start date
Q

quirthanon

I need to create a seperate sheet in an excel workbook that contains th
information from a data sheet.

There are multiple columns and I need to seperate the rows out tha
match values in one column.

Number Status Notes
1 Fail none
2 Pass none
3 Not Run none
4 Missing none

I need to make a seperate sheet for fail, pass, not run, and missing.
I would like these sheets to update automatically, as the data sheet i
quite large and it would take sometime to update the information b
hand.

Thanks,
Quirthano
 
I'd steal code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

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


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