SafeFeel.com

Free Computer Networking Security & Software Questions and Answers Website

How do you create a summary page in Excel from multiple sheets in a workbook?

I own multiple sheets surrounded by duplicate format beside different notes. I want to create a summary sheet contained by the workbook by linking to cell within other worksheets. Once I set up the first row linking to cell contained by the first sheet, how can I copy and bond to the subsequent row so that it will intermingle up to equal cell location surrounded by the second sheet surrounded by the workbook and so forth? Thanks within mortgage. Teri


Answers: I imagine you hold to do it individually... i don't deliberate it will riddle it surrounded by similar to that for you. You own to join a intermingle but I have a sneaking suspicion that you already know that.

The singular other article to do is do it by formula. double click on the contact you basically paste and after redeploy the formula for respectively.