Returning a value from another worksheet

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

I have created a financial spreadsheet and would like to
create a formula which returns the value in another
worksheet. The problem is that I cannot work out how to
move from, e.g. =Sheet4!D34 to =Sheet4!F34 and then to
=Sheet4!G34, etc. without doing it manually.

Thanks
 
Hi Stuart!

Make sure that you have:

Tools > Options > Edit
Check "Allow cell drag and drop"

Having entered =Sheet4!D34

select it
Point to bottom right corner of the cell until you see the plus
Left click and hold down
Drag as many cells across as you want.

Or select the range (eg) containing your =Sheet4!D34 as the first cell
Press F2
Press and hold down Ctrl then press Enter

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Norman,

Thanks for your prompt reply.

Unfortunately this does not work because it returns only
the next cell in sheet 4, i.e. E34 and not F34 which is
the one required. What I would like to do is return the
cell which is two to the right of the original cell. I
need to return D34 then F34, H34, J34, etc.

Regards,

Stuart
 
Hi Stuart!

Sorry! but I thought you had an error in first post as the third cell
you wanted was the next.

Use the following:

=OFFSET(Sheet4!$D$34,0,(COLUMN(A1)-COLUMN($A$1))*2)
Copy across and it will give you:

Sheet4!D34, F24, H34, J34




--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Stuart!

Always pleased to help and for confirmations that solutions work as
described.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top