| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Keep original cell formatting when using transpose array formula
I am currently using the array formula:
=TRANSPOSE(DataSheet!$AH$1:$BX$8) to transpose a set of data from another sheet. However, the cell formatting (specifically cell color) does not transpose with this array formula as it does when you simple paste transpose is there a way to edit this array formula to preserve the original cell color? Preferably not VBA as this doc will be shared with many who don't necessarily want to allow macros Secondly (hope its ok to ask in same post) I would like this same data set to be copied and pasted next to what i'm talking about above and be 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 did this manually and would like it to be automatic stemming from my datasheet) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to re-initialize cell with original formula | Charts and Charting in Excel | |||
| Original cell formatting clears when I move contents | Excel Discussion (Misc queries) | |||
| formula copies value from original cell only | Excel Worksheet Functions | |||
| Can I keep the original cell formatting when using FILL? | Excel Discussion (Misc queries) | |||
| Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
Threaded Mode
