LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 7
Default Sort by Date and Copy results to another sheet

I'm still working on my little project and can't seem to find what i'm looking for in any of the forums or help files, I know it can be done as I did it a college.

using the following data example

Date Time Name details

11/03/08 17:00 greg wanted to party
12/03/08 10:55 fred wanted help
13/03/08 11:45 paul wanted to speak to dave
13/03/08 13:30 harry wanted to go home

I want to leave the data intact and un edited in the main sheet above, and have a way to find all the data with todays date and copy them to another sheet at the push of a single button.

So i'd get a report on sheet 3

13/03/08 11:45 paul wanted to speak to dave
13/03/08 13:30 harry wanted to go home

Any ideas or good places to look for what I need.

Many Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I sort excel 03 sheet by date order? Mrblandings Excel Discussion (Misc queries) 1 March 12th 08 12:31 PM
COPY SAME DATE/CELL TO EVERY SHEET? Steve Excel Discussion (Misc queries) 8 October 2nd 06 07:25 PM
how do i copy various sheets date to one sheet in the same excel . Dinesh Excel Worksheet Functions 0 September 15th 06 02:06 PM
How to copy records containing a specific date range to new sheet? Chrys Excel Worksheet Functions 1 January 30th 06 08:19 PM
vba to sort group copy paste to another sheet mango Excel Worksheet Functions 0 November 5th 04 04:27 AM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"