C
Claire Charron
I am currently using the array formula:
=TRANSPOSE(DataSheet!$AH$1:$BX$8)
to transpose a set of data from another sheet. However, the cel
formatting (specifically cell color) does not transpose with this arra
formula as it does when you simple paste> transpose
is there a way to edit this array formula to preserve the original cel
color? Preferably not VBA as this doc will be shared with many who don'
necessarily want to allow macros
Secondly (hope its ok to ask in same post) I would like this same dat
set to be copied and pasted next to what i'm talking about above and b
sorted by cell color on top. is there a formula for this?
appreciate any help! thank you!
(Please see attached for what it should ideally look like, though I di
this manually and would like it to be automatic stemming from m
datasheet
+-------------------------------------------------------------------
|Filename: EXCEL EX.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=287
+-------------------------------------------------------------------
=TRANSPOSE(DataSheet!$AH$1:$BX$8)
to transpose a set of data from another sheet. However, the cel
formatting (specifically cell color) does not transpose with this arra
formula as it does when you simple paste> transpose
is there a way to edit this array formula to preserve the original cel
color? Preferably not VBA as this doc will be shared with many who don'
necessarily want to allow macros
Secondly (hope its ok to ask in same post) I would like this same dat
set to be copied and pasted next to what i'm talking about above and b
sorted by cell color on top. is there a formula for this?
appreciate any help! thank you!
(Please see attached for what it should ideally look like, though I di
this manually and would like it to be automatic stemming from m
datasheet
+-------------------------------------------------------------------
|Filename: EXCEL EX.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=287
+-------------------------------------------------------------------