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.
Bookmarks