+ Reply to Thread
Results 1 to 9 of 9

Insert Value according to month and date value

  1. #1
    Registered User
    Join Date
    02-17-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    86

    Insert Value according to month and date value

    Hello friends


    i am doing a program in manpower statistics report in excel,

    I want to insert value according to date and month from another sheet using as front page.



    i attached a file with this page, \

    kindly help me to fix this issue,
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Insert Value according to month and date value

    Hi beneesetas14, could you put in some sample data in the spreadsheet with expected result and some description?


    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

  3. #3
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Insert Value according to month and date value

    Do you need the values to stay in the 'Day' sheet?
    Or each time you enters different data in 'Front Page' only 2 specific cells in 'Day' sheet that matches will show the values?


    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

  4. #4
    Registered User
    Join Date
    02-17-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    86

    Re: Insert Value according to month and date value

    thanks for your reply

    i want to values need to stay in the cells corresponding to date and month

    and when date and month change in front page, its need to add in daily manpower sheet on according to date n month of front page


    example

    if

    month : march
    date : 2

    sapl :5
    ajc : 10

    this value to be insert to daily report manpower sheet to the cells of date : 2 & month : march and this value need to be fixed on this cell

    and once if i change the

    Month : april
    date : 3

    value need to be add on april and date : 3 on daily report sheet

    on the place of SAPL and AJC

  5. #5
    Registered User
    Join Date
    02-17-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    86

    Re: Insert Value according to month and date value

    Re: Insert Value according to month and date value

    thanks for your reply

    i want to values need to stay in the cells corresponding to date and month

    and when date and month change in front page, its need to add in daily manpower sheet on according to date n month of front page


    example

    Month : march
    Date : 2

    SAPL :35
    AJC : 199

    this value to be insert to Day sheet ( Daily Manpower ) to the cells of

    Date : 2

    Month : march

    and this value need to be fixed on this cell

    Once if Date and Month change like

    Month : April
    Date : 3

    value need to be add on Day Sheet ( Daily Manpower ) to the cells of SAPL and AJC where
    Month :April
    Date : 3

    to be add on this cell


    Once the value added from front page sheet to day sheet, its should be fixed

    thanks
    Attached Files Attached Files

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Insert Value according to month and date value

    Try in D10:
    =INDEX(Day!$B$4:$Y$34,$D$7,MATCH($D$4,Day!$B$2:$Y$2,0)+(D$9="AJC"))
    Copy to H10
    Quang PT

  7. #7
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Insert Value according to month and date value

    Hi beneesetas14, Excel formula will not be able to accomplish your goal.
    Would you consider using Excel macro, i.e. adding a button to your [Front Page] and once click will add the value to respective cells in sheet [Day]?

    ps: what if existing cells [Day] already having values and you're entering new values on the same date, ignore?


    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

  8. #8
    Registered User
    Join Date
    02-17-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    86

    Insert Value according to month and date value

    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


    kindly help me with vba source code to fix this issue

    thanks
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    01-01-2013
    Location
    melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: Insert Value according to month and date value

    hows this. i made a button
    Manpower.xlsm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically insert todays date as a month?
    By AllenMead in forum Excel General
    Replies: 3
    Last Post: 09-06-2010, 10:58 AM
  2. Insert Value from Cell If Date in Particular Month
    By improveddc in forum Excel General
    Replies: 1
    Last Post: 02-18-2009, 12:21 PM
  3. Insert Row with month of date change
    By cindy7 in forum Excel General
    Replies: 2
    Last Post: 07-30-2007, 07:14 AM
  4. [SOLVED] how to insert month date year and day of week
    By Sachi Noma in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-18-2006, 10:10 PM

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