Announcement

Collapse

ALERT - Threads Not Displaying

A large number of threads from the last 12 months are no longer displaying in the individual Forums. The technical team is aware of the problem and we are working to resolve it. We apologize for the inconvenience. Thank you for your patience.
See more
See less

Excel Formula's

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Formula's

    Ok, I need a webpage or something for help on dynamically creating formula's in MS Excel 2000. I want to input a date in one cell, and call information from another worksheet based on that date.

    ie: In the main sheet, there's a cell with 02/02/00 (user input).
    There's a few sheets named S020200.xls, S020300.xls, S020400.xls, etc.
    I want to dynamically call data from whichever sheet the user inputs for the date in the main sheet.

    This make any sense at all?

  • #2
    Re: Excel Formula's

    Start with this web page http://www.cpearson.com/excel.htm
    links from here also goto Excel Guru's


    http://www.cpearson.com/excel.htm

    Comment


    • #3
      Re: Excel Formula's

      Start with this web page http://www.cpearson.com/excel.htm
      links from here also goto other Excel Guru's


      http://www.cpearson.com/excel.htm

      Comment

      Working...
      X