Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Selecting a row based on a date in a cell

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Benjamin
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have 4 spreadsheets that allow the user to enter weekly data. Thata data is summarized by week for the District. That data then needs to be summarized by District for The Region. My question is this:
    Row1 from user1 is = week1
    Row2 from User2 is = week1
    Row3 from user3 is = week1
    Row4 from user4 is = week1
    Row5 is a total of all four users for the district.
    On another sheet I have:
    Row1 = District1 for week1
    Row2 = District2 for week1
    etc.
    The weekending dates are in column A of each row.
    What I want to do is something like =if(B5 <> "" (note A5 has week ending date)then copy DistrictRow5 to Region Week1, if(B11(note A11 has week ending date)then copy DistrictRow5 to Region Week2) etc.
    Can this be done or am I making this to hard.

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Benjamin
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I did not do this correctly either

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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