training in excel - Automatic importing from other worksheets. | Excel forum

Hi Rory,

If I understand your correctly, you wish to collate costs and profits from a source worksheet in a one workbook and have them display in a summary sheet in a separate Excel workbook.

This can be done by linking the source workbook to the summary workbook.

The steps are as follows;
1. Have the source workbook and your intended summary workbook open.
2. In the summary worksheet place your cursor in the cell you wish to display your totals.
3. Insert the = sign to begin the link.
3. Using your mouse, click on the cell on the source worksheet that holds the total figure of interest and hit the Enter key to complete.

Repeat this process for other totals.

For ease of navigation, a suggestion would be to select from the Windows menu, the Arrange > Tiled options. This allows worksbooks to be viewed at once.

Hope ths helps