The mg/L column is copied, then pasted in transpose into another worksheet. First, ensure that the IS ratio column is used unless another has been selected, then add a button to copy it to clipboard in transpose form. This is done by copying to the clipboard, extracting from the clipboard into a variable, replacing the newlines with tabs, and pushing it back to the clipboard.
The mg/L column is copied, then pasted in transpose into another worksheet. First, ensure that the IS ratio column is used unless another has been selected, then add a button to copy it to clipboard in transpose form. This is done by copying to the clipboard, extracting from the clipboard into a variable, replacing the newlines with tabs, and pushing it back to the clipboard.