Forum Discussion
Copy transpose formula between workbooks as text
Hi, I'm stuck with the above problem. I am copying various formulas from one worksheet to a worksheet in a different workbook. Each worksheet has the same worksheets and layouts on them. To avoid...
Sorry, I meant each workbook has the same worksheet labels and data layout.
I found a workaround. I created two templates: the first pasted formulas that excluded the transpose commands, then the second added them. But the cells with a transpose formula had to be in the last row of the template, otherwise they could cause spill errors.