Forum Discussion

NotSoFastEddie's avatar
NotSoFastEddie
Brass Contributor
May 19, 2024

Carry over cell formatting from source worksheet to destination worksheet generated via LET (TAKE 2?

Not sure if the first request is out there somewhere.  

 

I have created a custom format(s) '#0.00 " in"' so when a value is entered, it displays "1.00 in".  Using a LET statement on a destination worksheet, the data is filtered and copied over.  However, the custom format is not copied over.  Is there a way to do this?

 

=LET(
features_tbl, FILTER('pty-linkProductFeatures_Base'!$A$1:$BG$1600, 'pty-linkProductFeatures_Base'!$A1:$A$1600<>""),
data, DROP(DROP(features_tbl, 1, 2),, -1),
keys, DROP(HSTACK(TAKE(features_tbl,, -1), TAKE(features_tbl,, 2)), 1),
specNames, DROP(DROP(TAKE(features_tbl, 1),, 2),, -1),
code, XLOOKUP(specNames, Table_Specifications[Attribute name], Table_Specifications[[Classification Attribute ]], "not found"),
typevalue, XLOOKUP(specNames,Table_Specifications[Attribute name], Table_Specifications[Feature Type], "not found"),
a, SEQUENCE(ROWS(data)),
b, SEQUENCE(, COLUMNS(data)),
CHOOSECOLS(
EXPAND(
HSTACK(
CHOOSEROWS(keys, TOCOL(IF(b,a))),
TOCOL(IF(a,code)),
TOCOL(IF(a,typevalue))&","&TOCOL(data)
),, 7, ""),
2, 3, 4, 5, 6, 7, 1
)
)

 

 

Resources