B buddy1000 Active Member Joined Oct 31, 2007 Messages 294 Apr 7, 2009 #1 hi... In column A I have values vertically. (A1: A100) i link D1 to A1. If I drag it horizontally it does not gives the correct values. Is it possible to drag it in a correct way?