Copying a range from 1 sheet to another

How do I copy a range of cells from 1 sheet in a workbook to another sheet inthe same workbook with the following stipulations:

1) All formatting needs to be copied.2) All formulas need to be copied.3) All values need to be copied.4) The cells need to be linked.

The idea is that one sheet has running totals for different types of widgets(thousands of lines), and there is a summary row of data and formulas for eachwidget. The summary rowwill be copied to a separate sheet to provide a synopsis at a glance of allwidgets.

Share:

1 Answer Found

If the formula reads =sum(A1:C9) and it is on Sheet1 then you need torewrite the formula to state =sum(Sheet1!A1:C9)... assuming you arepasting the formula in the same cell relative to Sheet1. Pasting themanywhere else would require your formula to be =sum(Sheet1!$A$1:$C%9)

Then copy and paste will do the trick.

Or, just link the formula from the new sheet =Sheet1!B2. And, thenuse the Format Painter to copy the formatting.