Need help with selecting a range of data for a function.

W

web1000

Hi There,

I have the problem that I have large files with data from which I need
to select a section based on their values.

I have one column with date and time and one column with values.

I need excel to prompt for a start date and time and end date and time
via a macro or built in function (VBS?).

I then need excel to perform all calculations based on the range it has
to pick based on the dates and times ...

I can not figure out how to to this sort of addressing :(

Any help is appreciated!

Matt
 

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

Need Help with a VBA subroutine 0
Creating a Chart on form from selected data in query. 0
Calculate the median value before a specified list 0
Viso Wizard no launching? 0
Use TODAY() function as the criteria in a SUMIF formula 1
Word macro that can call cells out of Excel for a find and replace 0
Formatting Rule: Diplay Section based on Selection in another section 0
calculate total hours based on dates 5

Top