simple question

I

Iain Wicks

Hi I want to reference a cell in another worksheet and
can't quite get the syntax right.
This is what i did when i want to display the contents of
A14 in Sheet 2.
=('sheet 2',A14)


Can you help
 
L

Leo Heuser

You're almost there :)
The syntax is
=('sheet 2'!A14)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Change different cell based on conditional statement 4
check certain cells for data before saving file 5
Sumproduct, 3 columns and date 3
IF & VLOOKUP 4
VBA Coding Help for Beginner 0
Remove specific cells in a column. 2
How can i join these two formulas? 5

Top