Okay here it goes, The attached book on the day sheet needs to have columns c-p from row 1-37 need to be transposed to another book. That is the simple part. The problem I am having is that there needs to be multiple copies of each column based on the number of specific cells in that column that are greater than 0 (60,62,64,66,68,70,72,74,76,78,80,82). So if column c has rows 60,64,70 greater than 0,then there would be three copies of column c transposed. Is this a possibility at all? and does anyone want to take on the challenge?
Bookmarks