+ Reply to Thread
Results 1 to 4 of 4

Auto Pick Only "Specific Day & Date" & put in "specific cells" Vertically

  1. #1
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Sweden
    Posts
    311

    Auto Pick Only "Specific Day & Date" & put in "specific cells" Vertically

    Greetings to everyone

    i m facing a problem and been stuck in it form many days, & cant able to solve it

    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")

    Leaves Records Sample.xlsx

    Attendance.jpg

    this will help me out to maintain Full year record of (M/L C/L, H/L) taken of specific Person date wise

    your kind help will be highly appreciated

    Best regards
    Last edited by pipsmultan; 08-24-2014 at 03:55 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Auto Pick Only "Specific Day & Date" & put in "specific cells" Vertically

    Maybe like the solution offered in this treat.

    http://www.excelforum.com/excel-form...ml#post3810437
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Sweden
    Posts
    311

    Re: Auto Pick Only "Specific Day & Date" & put in "specific cells" Vertically

    it was advice not the solution

  4. #4
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Sweden
    Posts
    311

    Re: Auto Pick Only "Specific Day & Date" & put in "specific cells" Vertically

    any solution or alternate from anyone will be highly appreciated

+ 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. [SOLVED] :confused: Auto pick "specific data" and put it in "specific cells" with date
    By pipsmultan in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 08-27-2014, 03:31 AM
  2. [SOLVED] Convert from "general" (YYYYMMDD) to specific "custom" format (YYYY.MM.DD)
    By Ella_p in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2013, 02:23 AM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Auto "Page Numbering" in a "specific Cell"
    By BigChuckMeister in forum Excel General
    Replies: 2
    Last Post: 04-08-2013, 05:25 PM
  5. Using DMIN to evaluate "less than" or "greater than" a specific date
    By williams485 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-01-2012, 12:45 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