| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select entries between two dates?
How do I copy and paste to another spreadsheet all entries betwen two dates?
The data covers columns "A:J" and dates for a year. There may be several entries in one day as well. Thank you -- Bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select entries between two dates?
First sort the data by the Date column. Then you can copy/paste in a single
block. -- Gary''s Student - gsnu200844 "Bob" wrote: How do I copy and paste to another spreadsheet all entries betwen two dates? The data covers columns "A:J" and dates for a year. There may be several entries in one day as well. Thank you -- Bob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select entries between two dates?
Is there a code or formula that can be used, when inserting two dates it does
it automatic? -- Bob "Gary''s Student" wrote: First sort the data by the Date column. Then you can copy/paste in a single block. -- Gary''s Student - gsnu200844 "Bob" wrote: How do I copy and paste to another spreadsheet all entries betwen two dates? The data covers columns "A:J" and dates for a year. There may be several entries in one day as well. Thank you -- Bob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select entries between two dates?
Hi Bob.
Autofilter is great for this. First click anywhere in your list, then go to Data menu, filter, Auto Filter. It will give you the drop down options in your heading row. From your dates heading drop down select Custom option. Select: greater than or equal to first date ans less than or equal to last of your dates. the filter will hide dates you do not want. then you can copy and paste the entries you need to another worksheet. "Bob" wrote: How do I copy and paste to another spreadsheet all entries betwen two dates? The data covers columns "A:J" and dates for a year. There may be several entries in one day as well. Thank you -- Bob |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select entries between two dates?
Thanks Maggiec that works manually, is there a vb code that would do that
automatic if two dates where entered in two cells? ie: Cell A1=01-Jan-09 Cell A2=31-Jan-09 -- Bob "maggiec" wrote: Hi Bob. Autofilter is great for this. First click anywhere in your list, then go to Data menu, filter, Auto Filter. It will give you the drop down options in your heading row. From your dates heading drop down select Custom option. Select: greater than or equal to first date ans less than or equal to last of your dates. the filter will hide dates you do not want. then you can copy and paste the entries you need to another worksheet. "Bob" wrote: How do I copy and paste to another spreadsheet all entries betwen two dates? The data covers columns "A:J" and dates for a year. There may be several entries in one day as well. Thank you -- Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Entries between two dates | Excel Discussion (Misc queries) | |||
| Random select entries | Excel Discussion (Misc queries) | |||
| Dates: How many entries per week? | Excel Discussion (Misc queries) | |||
| putting dates next to entries | Setting up and Configuration of Excel | |||
| How do I Select Multiple entries from Valid list for a Cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
