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.