Hello
i am trying to use excel to 2013 to copy a column in sheet1 to a row in sheet2.
by using transpose i can copy the data from the column to the row but cant seem to link each cell to its appropriate cell i.e. - A2 (sheet2) to B1 (sheet1) , B2 (sheet2) to B2(sheet1) C2 (sheet2) B3(sheet1) ect
also any cells on sheet 1 with no data value to be linked to sheet 2 - at the moment if there is no data in the cell it does not link. it does link if i do it manually so am hoping there is a function for this.
any help gratefully received - before my swear box over flows !
thanks Sarah
Bookmarks