Data searching based on cell contents using VBa

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Excel VBA 1
Countdown 1 every workday 3
Set variable date range in query? 1
query criteria based on a changing list of values 2
Multiple Conditions - VBA 1
Predictive Text based on cell range? 1

Back
Top