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;
全站熱搜