<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 500 points for Flyster's comment <a href="https://www.experts-exchange.com/questions/28706632/Create-Analysis-of-sheet-totals.html?anchorAnswerId=40936170#a40936170" rel="ugc">#a40936170</a><br />
<br />
for the following reason:<br />
<br />
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


I've requested that this question be closed as follows:

Accepted answer: 500 points for Flyster's comment #a40936170 [https://www.experts-exchange.com/questions/28706632/Create-Analysis-of-sheet-totals.html?anchorAnswerId=40936170#a40936170]

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I have 2 sheets in Excel workbook, 1 has 3 months of data totals, the other has 4 months (averages).<br />
<br />
I'd like to create a 3rd sheet that has the column with totals from each sheet side by side for comparison.<br />
<br />
I don't really want to cut and paste formulas, etc. &nbsp;Is there a simple way to set the column data to pull the entire column from another sheet? &nbsp;If so, I can't find where to set that up.
</div>
</div>


I have 2 sheets in Excel workbook, 1 has 3 months of data totals, the other has 4 months (averages).

I'd like to create a 3rd sheet that has the column with totals from each sheet side by side for comparison.

I don't really want to cut and paste formulas, etc.  Is there a simple way to set the column data to pull the entire column from another sheet?  If so, I can't find where to set that up.

Create Analysis of sheet totals

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.