Forum Discussion
referencing text format
Hello everyone, In my excelsheet I am referencing tables using VSTACK to create one master table, while keeping it easy to edit the original tables. The problem that I am facing is that VSTAC...
Hi, you already said it yourself in your request. VSTACK() has no option to pass the formatting. None of the other functions can do this either.
The only possibility I can see now is that you add an additional column in your original tables that contains a code for formatting. You can leave this column hidden as long as you don't need to expand it. You can then use the code in your master table and add the formats using conditional formatting.
However, this is quite time-consuming. Depending on how many different formats you use.
Maybe someone will come up with a better idea.