Open both workbooks. From one workbook, in a cell type "=" then click on a
cell in the other workbook. Hit enter.

If you inspect the cell from in the first workbook, it will show you how to
reference the other workbook.

Scott

"Miikka Hamalainen" wrote:

Hi,

I'm making statistic analyzes for school project and I have problem.

I have been trying to get values from another workbook to the one I'm making
statistical totals.

I would like to get the info straight from the workbook, without copying it
first to the main workbook.

I have made CommandButtons to the main sheet and have been trying to use
Worksheet and Workbook statements without success.

Does anyone have good tips to solve this?

Br, Miipe