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

excel

ResolvedVersion Standard

Chantel has attended:
Excel Intermediate course
Excel Advanced course

Excel

how do we feed data from one sheet to another

RE: excel

Hi Chantel, Thank you for your post, in answer to your question, the most straighforward way of linking data from one sheet to another is to use the equals sign (=) in your destination cell, then navigate to the cell you wish to link to (source), select it and press the enter key. This now ensures that any data in the source cell will be displayed and is available to be used in any formulas or functions from the destination cell. Note any changes made in the source cell will be reflected in the destination. I hope that helps, best regards Pete.

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

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.