close

Hello. How can I get in a worksheet all the values of let's say cell A5
or column B from several different worksheets?--
ErwinR
------------------------------------------------------------------------
ErwinR's Profile: www.excelforum.com/member.php...oamp;userid=29595
View this thread: www.excelforum.com/showthread...hreadid=492974Hi

Do you mean
=SUM(Sheet1:Sheet10!A5)
This will sum the values of cell A5 across all 10 sheets.

Regards

Roger GovierErwinR wrote:
gt; Hello. How can I get in a worksheet all the values of let's say cell A5
gt; or column B from several different worksheets?
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()