+ Reply to Thread
Results 1 to 1 of 1

Record Seat No every cell change on a range of cells

  1. #1
    Registered User
    Join Date
    06-15-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    1

    Talking Record Seat No every cell change on a range of cells

    I have a cell range ie. C4:CX33, if i put an "x" on a cell within range, a certain seat no calculation will be copied to a column ie. DD1 . If 5 cells selected , 5 values also will be copied or inputted automatically. if cell DD1 has value on it it will put the current value to the next blank cell DD2.

    if C4 = x then DD1 = seat no ie 2901.

    if C4= x, AA12 = x, BB20 = x then

    DD1 = 2901
    DD2 = 2125
    DD3 = 1152

    attached here is the file. Please help.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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