Vlookup in different worksheets

E

ErwinR

Hello. How can I get in a worksheet all the values of let's say cell A
or column B from several different worksheets
 
R

Roger Govier

Hi

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

Regards

Roger Govier
 
Top