training in excel - Automatic importing from other worksheets.

The UK's most regular instructor-led training courses.
Training information: training in excel · Excel advanced · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

1 post

ReplyMon 8 Jan 2007, 10:49Delegate Rory said...

Rory has attended:
Outlook Advanced course

Automatic importing from other worksheets.

We have a spreadsheet for each job totalling costs and profit . Can we get the total for each project to be automatically sent to a central document for easy reference. At the moment we have to open each file and get figure and then close it and move onto the next one.

Many Thanks

Rory Dunn

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Thu 18 Mar 2010	Bloomsbury	2		£224	£225
2003	Thu 18 Mar 2010	Limehouse	0	FULL
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	6		£199	£204
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
Full Schedule: See all 79 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

29 posts

ReplyTue 9 Jan 2007, 10:10Trainer Orok said...

RE: Automatic importing from other worksheets.

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

7 posts

ReplyThu 11 Jan 2007, 10:06Delegate Bowen said...

RE: Automatic importing from other worksheets.

If you highlight the cell you want to copy from (and presumably the cell that continually updates) copy the cell and then go to your central document and place the cursor in the cell where you want this new figure to appear.

Then you can Edit/Paste Special/and click on the Paste Special button at the bottom left. That way it should continually update as the original figure updates.

That's one way, perhaps Best training can advise you of a faster way.

· How to Create Better Excel Spreadsheets: Part Two
· Simple Ways To Customise Excel
· Tracking In Excel 2003
· A Picture Is Worth A Thousand Words (Or Numbers)
· Excel and Inventory Management

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips