Copying a Sheet


I have a excel work document where the first two sheets have identical information, but the second one also includes percentages. I want to format it so that when I change numbers, add/delete rows in the first sheet, it automatically does so in the second. So far I have figured out how to make it so that when you change a cell in sheet 1, the information also changes in sheet 2 however I cannot find a way in which when I add a row in row 10 for example, it also adds the same row 10 automatically in sheet 2.

Please let me know if anyone has a solution.

Thank you,

By: Anusha

Leave a Reply

Your email address will not be published. Required fields are marked *