How to create an executive summary of a text-based data list?
How to create an executive summary of a text-based data list?
Hi! I have one worksheet filled with a text-based multiple-column list. On a separate worksheet, I am trying to insert just a few of the columns to function as an executive summary of the big list. How can that be done in a way that data is automatically updated in the exceutive summary worksheet whilst I add stuff to the big list? Thanks in advance! Best regards, Magnus. |
How to create an executive summary of a text-based data list?
Hi
You can provide referecial link between cells. for example: you would to update the cell "A1" in "sheet2" with the value in cell "B2" at sheet1. Then you can write in "A1" at "sheet2" like =Sheet1!B2 copy this formula to other cells in the same column. Hope this will work! Regards Vikas Kumar. "Magnus" wrote: How to create an executive summary of a text-based data list? Hi! I have one worksheet filled with a text-based multiple-column list. On a separate worksheet, I am trying to insert just a few of the columns to function as an executive summary of the big list. How can that be done in a way that data is automatically updated in the exceutive summary worksheet whilst I add stuff to the big list? Thanks in advance! Best regards, Magnus. |
All times are GMT +1. The time now is 03:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com