I have six cells and only one of those cells is colored and has data...
Example
F G H I J K Y
1 blank blank data blank blank blank Copy cell that's not blank here
2 blank data blank blank blank blank Copy cell that's not blank here
3 blank blank blank blank blank data Copy cell that's not blank here
ect.
Is thier anyway to do this and to keep the cell color as well as the data?
Thanks,
DJ