Hi, I am using 2 worksheets tabs. I have the data entered monthly for 30 items and each for 7 years, and listed horizontally on the 1st sheet. I wanted to link the cells on the second sheet by item & month to the first sheet; however, I need to have them listed vertically while still remaining linked to their corresponding monthly cell. I have tried copy paste special link, and have tried to transpose, but it didn't work? Is this possible? Any suggestions would be greatly appreciated.