Copy data from one column to another

You can copy the data from any manual entry column to another.

To add line items by copying existing data from one column to another

  1. Open the project or shell Cost Sheet window, click the Edit menu and choose Copy > Column Data. The Copy Column Data window opens.
  2. Complete the Copy Column Data window as described in the table below.
  3. Click Copy. The data in the first column will be copied into the second column.

In this field

Do this

Copy type

Choose one of the following:

  • Cell total only: Copies the total value displayed in the cell. The new line item will be labeled as "Copy of original column name," ignoring quantity and unit cost.
  • Cell detail: Copies all cell detail information from the original line item.

Copy from column

From the drop-down list, select the column to copy. Only line item entry columns will be listed.

Percentage

You may enter a percentage value to copy. For example, if you choose 10%, then 10% of the value of the original column value will be copied into the new column.

Copy to column

From the drop-down list, select the column into which you want the line items copied

Rows

Choose one of the following from which you want to copy the values:

  • All: To copy values to all of the rows.
  • Partial: To copy the values of selected rows only. Click the Select button to choose the rows to copy.


Legal Notices | Your Privacy Rights
Copyright © 1998, 2022

Last Published Monday, April 11, 2022