This Analytics Edge wizard is used to write the results of an analysis to a worksheet. It can either overwrite an entire sheet, or be written to a specific location. It can also optionally copy the results to a Google Sheets file as well.
It is normally the last step in an analysis sequence, but the macro can continue processing data and write to other worksheets or files.
Worksheet – enter a name for the worksheet to write to (located in the current workbook). If the worksheet does not exist, it will be created.
Replace entire worksheet – removes all data and formatting before writing the contents of the table to the worksheet. Prevents old data from remaining in a worksheet if the new results do not use as many rows or columns.
Insert into worksheet – specific the top-left cell for the results to be written to. This option will only clear a range big enough to write the data from the table.
Do not include header – check this to prevent the column names from being included in the first row of the results written.
Do not clear cell formatting – this option will only change the cell values and not affect any cell formatting in place. Note that this can cause problems if the format of the cell does not match the data.
Transpose – check this to write each column as a row in the worksheet.
Add hyperlinks to web addresses – if the results include web addresses, they will be converted to hyperlinks that can be clicked on.
Format as Excel table – format the output as an Excel table using one of the predefined Excel formats. Select from the formats listed or pick the empty entry for no color formatting.
CAUTION: do NOT try to write to a range that includes merged cells!
Copy to Google Sheets – click the Select/Modify button to send a copy of the results to a Google Sheets worksheet. This is an alternative to using a separate Write to Google Sheet function. See: Write to Google Sheet.