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.
|