+ Reply to Thread
Results 1 to 1 of 1

Form with range change based on dates

Hybrid View

  1. #1
    Registered User
    Join Date
    08-24-2010
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2003
    Posts
    1

    Form with range change based on dates

    Hey there, just thought I would see if any of you guys can help me with my problem on excel. If there is anyone who can, it will be on here. I'll try my best to explain what I need the best I can. I have attached the file for reference and clarity sake. I want to be able to make a "form" in a sense, and all you have to do is enter in a quarterly date range, (look at my excel document, the first tab there is a "start date" and an "end date"), and based on that date range, calculate "Beta" (click on the Statistical Analysis tab) and each of the other calculations based on only the date range specified. I know I can go in a manually find and replace the cells, but my boss wants to be able to pick a range of quarterly dates and have all the data in one spot. Hope I explained it well enough. Let me know if there needs to be any more clarifying. Thanks in advance!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1