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.