In Sheet2 enter =Sheet1!A1 in an appropriate cell.

Or error-trapped for blank cells in Sheet1

=IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

On Sat, 16 May 2009 11:10:01 -0700, Millie
wrote:

I know it's possible to link cells from one worksheet to another but not sure
if what I want to achieve is possible (I use only the basic functions in
Excel).

I want to insert information into one sheet and have a version of that
information appear in another sheet. For example, I have a list of jobs I've
been commissioned to do in sheet 1 and they are in a list in date order, how
much I got paid and what the job was. In another sheet I have a list of
people who've commissioned me to do work and what the job was - so I can see
at a glance who is offering me the most work. Some of the information is
repeated e.g. the job, the date etc.

At the moment I am manually typing in the same information in each sheet.
Can I link cells so that any info repated autmatically appears in the second
sheet?