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: 562
I am using Excel 2010.
I got a sheet name "March"
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