filtering problem

  • Thread starter Thread starter rutima - ExcelForums.com
  • Start date Start date
R

rutima - ExcelForums.com

Hi all,
I have a worksheet imported from access looks like this

Date Supplier Sets Ctns ON Status
10/10/2004 Tom's 2356 0 123456 Rolled
12/10/2004 Bill's 0 23454 23355 NS
13/10/2004 Ted's 0 111 453656 Sch

In this workbook there are 28 worksheets one for each day of th
month/four week periods, I need to split the results from th
imported worksheet
a) so they appear on the right date worksheet.
b) they appear in Status order - example Rolled in A12-B12-C12-D12 et
for all the data and NS in T44-U44-V44 etc.
I hope this makes sense, how can this be accomplished.
any help appreciated.

Cheer
 
Maybe you can steal some code from Debra Dalgleish's site:

There are a couple of files here:

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
 
Back
Top