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.

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.


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

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.

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