Microsoft Excel 2010 How to reference a table to another sheet
- by Shiro
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!