Page 1 of 2 1 2 LastLast
Results 1 to 10 of 13

Thread: :confused: In Picking "specific data" and put it in "specific cells" with date

  1. #1

    :confused: In Picking "specific data" and put it in "specific cells" with date



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

    Greetings to everyone

    i m stuck into some issue ImageImage

    i hav 2 month & year from ("AE2" to "AI2") & ("AE7" to "AI7")

    in front of month Jan with Year 2014 (B3 & B4) i have Dyas from "D3 to AH3" and Dates "D4 to AH4" and from "D5 to AH5" it is filled with H/L, C/L, P, M/L etc. all these ("D3 to AH3, "D4 to AH4" & "D5 to AH5") are in horizontal format and same with case of month Feb with Year 2014 ("AE7" to "AI7").

    the problem i m facing i want these all horizontal format data (AE2 to AI2 & D3 to AH3 & D4 to AH4 & D5 to AH5) in vertical format

    I want cell "B19 to B23" to pick automatically "M/L" from "D5 to AH5" date wise ("dd-mm-yy" ) & C/L in cell "C19:C23", H/L in cell "D1923"

    as you can see in sample attach copy the cell "S3" (day) and "S4" (date) should display in cell "A19" with "dd-mm-yy" according to ("AE2" to "AI2")

    attach file link:

    Leaves Records2.xlsx

    Click image for larger version. 

Name:	Attendance.jpg 
Views:	11 
Size:	99.2 KB 
ID:	2590


    this will help me out to maintain Full year record of (M/L C/L, H/L) taken of specific Person date wise and data get update the record should also get updated in "S3" & "S4" across

    Best regards

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Are the numbers in row 5 dates that are formatted to just show the day number?


  3. #3
    Quote Originally Posted by NBVC View Post
    Are the numbers in row 5 dates that are formatted to just show the day number?
    sorry i dont get your point in row 5 there is (M/L, C/L etc)

    M/L = Medical Leaves
    C/L = Casual Leaves
    com/L = Compensatory leaves
    and soon

    can you give me a better view of what you are asking

    It's unclear to me.

    Regards

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    I meant row 4. If you select one of those cells what do you see in the formula bar?


  5. #5
    Quote Originally Posted by NBVC View Post
    I meant row 4. If you select one of those cells what do you see in the formula bar?
    i see the formula "=IF(R4<=EDATE($D$4,1)-2,R4+1,"")" in Formula bar

  6. #6
    Bump No Help (Solution) from anyone

  7. #7
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Hi, sorry for the delay. Also, I just noticed that you had posted an attachment spreadsheet link. Initially I thought you had only posted a picture....

    Anyway, try this formula in B19 copied down.

    =COUNTIFS($D$4:$AH$9,$A19,$D$5:$AH$10,"M/L")

    Similarly for other codes.


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

    by chance have you had a look at this?

  9. #9
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Hi NoS. Thank you for that.

    pipsmultan, please do not crosspost your questions to other forums without providing links. Please read this to understand why: http://www.excelguru.ca/content.php?184


  10. #10
    Quote Originally Posted by NBVC View Post
    pipsmultan, please do not crosspost your questions to other forums without providing links.
    Thanks, I respect an appreciate you for guiding me in the right direction
    I Just want to get more experts pointed to my posts, Thank you for informing me.

    regards

Page 1 of 2 1 2 LastLast

Posting Permissions

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