Forum Discussion
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
)
)
- Thanks I will give that a try.
- Harun24HRBronze ContributorTry TEXT() function like =TEXT(1,"#0.00")&" in"
- NotSoFastEddieBrass ContributorThanks I will give that a try.