Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel worksheets

by tjzz Oct 8, 2007 10:02AM PDT

I have a workbook with 15 worksheets. On the first worksheet, I would like to bring information from a specific cell (column) on another worksheet into a specific cell on the first worksheet. I've read the help information and I can not find the information on how to do this.

Then, when I have pulled in summary information from the other worksheets, I would like the cells in the first column of this same worksheet to be an average of all the cells in the following columns (which each cell/column equates to one of the worksheets).

Thanks for your help, Todd

Discussion is locked

3 Posts

- Collapse + Expand Details

- Collapse -

Re: excel worksheets

by Kees Bakker Oct 8, 2007 5:23PM PDT

Use sheetname!cell in the formula, just like you use cell in a formula if you reference to a cell in the same sheet.
So: =2*c2 becomes =2*sheet10!c2

Use the average function for calculating the average. What's the problem here?

Kees

- Collapse -

You can

by PudgyOne Oct 8, 2007 5:34PM PDT

copy

paste special

paste link

but you have to remember that if you cange the number in the cell after you paste it, the formula goes away.

The best way to do this would be to copy from sheet 1 and go from there.

Rick

- Collapse -

Some reading...

by Papa Echo Oct 9, 2007 1:12AM PDT

..from Microsoft itself...HERE

Back to Office & Productivity Software forum