Sorting out data by date

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

rutima - ExcelForums.com

Hi all
My problem is I have an imported spreadsheet from access tha
shows the date, Name of company and amount of goods.I then have seve
spreadsheets one for each day of the week. I need to put the record
for the right day on the right spreadsheet. the imported spreadshee
is updated every day, so the records change, is there a way to sor
these records out so they go to the right sheets. grouped

Cheer
 
I think I'd use a helper column and put:

=text(a2,"dddd")

Then sort by that column and copy|paste to the correct worksheet.

If I wanted a macro, I'd steal some 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