Microsoft Excel 2010 How to reference a table to another sheet

Posted by Shiro on Super User See other posts from Super User or by Shiro
Published on 2012-03-22T09:45:58Z Indexed on 2012/03/22 11:33 UTC
Read the original article Hit count: 502

Filed under:

I am using Excel 2010.

I got a sheet name "March" March Sheet

I would like to duplicate it (with reference / link) to another sheet called "Summary" which included January, Feb, and March.

In the summary tab I would add another column called "Month" and will duplicate the value "March" or their tab month.

I did some research on it, they said copy and paste special with link, but I can't find it.

I need to reference the whole table, just in case any change add / remove the row of the table, the summary still will update it. Is there any solution with this?

Thanks!

© Super User or respective owner