Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007
Edited on Fri 29 Nov 2013, 12:01

Nasima has attended:
Excel Advanced course

Excel

1. Can you link one spreadsheet to another spreadsheet?
2. Can you delete something from one spreadsheet and the same information will delete from the linked spreadsheet (if possible)?
3. How do you take the same information from one spreadsheet to another spreadsheet withou copying and pasting (especially when the information you are copying is scattered)?

can you do a v look up between 2 seperate spreadsheets?

RE: excel

Hi Nasima

Yes data from one spreadsheet can be linked to another spreadsheet. If it is a block of data the easiest way is as follows:

Open both spreadsheets
Copy the block of data from spreadsheet 1
Select a cell in spreadsheet 2
Choose Paste Special
Press Paste Link button

Then if data is deleted from spreadsheet 1 it will display as 0 in spreadsheet 2.

Also when opening spreadsheet 2 on its own you will be prompted with Options, choose Enable Content to display the latest changes made to spreadsheet 1.

If the data is scattered then copy / paste link wont work.
You can start in spreadsheet 2 and use the following method:

Select a cell
Press =
Navigate to spreadsheet 1
select the cell you wish to link
Press Enter

You will have to do this for all the date you wish to link.

You can also use this method to linka block of cell. But you have to remove the $ signs around the cells reference before pressing Enter. Then the linked cell can be copied down and across.

Please let me know if that helps Nasima

Regards
Doug Dunn
Best STL

Fri 6 Dec 2013: Automatically marked as resolved.

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.