Results 1 to 6 of 6

Input data to a table using 2 variables

Threaded View

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    Portugal
    MS-Off Ver
    Excel 2010
    Posts
    16

    Input data to a table using 2 variables

    I have a table that is going to be receiving values but I don't know how to calculate where to input the data.
    I couldn't upload via attachment so here is the link to fully understand the table I'm talking about - http://img841.imageshack.us/img841/3606/imagevu.png
    The departments are identified on the upside and the months of the year on the left.

    What is needed to know in order to calculate where the input will be:
    Identification of month (probably using the function TODAY to keep it updated, I don't know how to do this)
    AND
    Department (which is already identified in cell D4 of Sheet1)

    The information to input is at cell F8 in Sheet 1.

    EDIT: Is this too confusing?
    Last edited by Christophe.Zucchetto; 07-28-2011 at 05:54 AM.

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