| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data searching based on cell contents using VBa
Hi,
I'm trying to set range names and criteria for searching an excel data base based on start and finish dates. I want to be able to enter a start and a finish date in a cell, and then have the rest of the information sorted based on the start and finish date I select. I'm trying to setup some automatic graphing functions for an Admin Assistant -- Thankyou for your time |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data searching based on cell contents using VBa
Sorting does not seem the problem here. Pick the column with the dates and
sort it asending. The hard part will be finding the first occurance of the start date and the last occurance of the ending date, then you need rows above the start date with headers and an empty row below the ending date. Assumng all columns will be grahed, then you will have to select the region and graph it. Seems we would we data to start with. Good luck. "Craig Easton" wrote: Hi, I'm trying to set range names and criteria for searching an excel data base based on start and finish dates. I want to be able to enter a start and a finish date in a cell, and then have the rest of the information sorted based on the start and finish date I select. I'm trying to setup some automatic graphing functions for an Admin Assistant -- Thankyou for your time |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching alfanumaric cell contents and returning with a numaric v | Excel Discussion (Misc queries) | |||
| Searching in another workbook for a string and returning with the contents of the cell next to it. | Excel Worksheet Functions | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| Reference Data Range based on cell contents | Charts and Charting in Excel | |||
| Please help! Macro to change cell contents based on cell to the left | Excel Programming | |||
Linear Mode
