I am using Excel 2010.
I got a sheet name "March"
I would like to duplicate it[This is a table] (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?