| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
query info based on dates
I have a spreadsheet in Excel 97 with 15 columns of information, one of
which is a date entry. Is it possible to create a macro that will show a box in which to input a date range and then to bring back information from 7 of the other columns based on the date selection, and paste the information into a new workbook? Any help or guidance greatly appreciated. Regards Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Macro- Insert rows based on dates and copy info from that row | Excel Discussion (Misc queries) | |||
| sum of info in a range based on dates | Excel Worksheet Functions | |||
| Macro to put info into certain columns based on info in another co | Excel Discussion (Misc queries) | |||
| Sumproduct - Pulling info based on lenght of time between dates | Excel Worksheet Functions | |||
| varying validation info based on preceding info | Excel Discussion (Misc queries) | |||
Threaded Mode
