Results 1 to 2 of 2

Thread: Insert Value according to month and date value

  1. #1

    Insert Value according to month and date value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I doing a program in manpower statitics report

    I need to insert data from one sheet to another sheet according to date and month

    attach sample copy of file this thread

    in first sheet ( front page ) i have

    Month :
    Date :
    SAPL :
    AJC

    in second sheet ( day ) i have calendar of year 2014 with a column for sapl and ajc

    when i am adding value in first sheet in sapl and ajc column, this value need to insert on each corresponding columns of second sheet according to its
    Month and Date

    Example

    Month : March
    Date : 3
    SAPL : 35
    AJC : 199


    when i edit this value in first sheet,its need to be insert in second sheet according to the month and date ,
    like this i need to fill values in each cell in second sheet according to date n month



    thanks
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Hello beneesetas

    For the question you've asked you've already gotten your answer on another forum.

    http://www.excelforum.com/excel-form...ate-value.html
    http://www.excelforum.com/excel-prog...ate-value.html

    If that's not what you're after you'll need to explain why not and what it is you actually want.

Posting Permissions

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