Tech Support banner

Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
4 Posts
Discussion Starter #1
Need help with Excel formula

I need cell A1 on sheet 2 to match what is written in Cell A1 on Sheet 1.
I can manage to work it with numerical cells but I'm struggling to figure out how to do it with words only.

Please could someone help?

Thanks :sayyes:
 

·
Superhuman Computer
Joined
·
1,632 Posts
I'm not positive where the problem is that you're having, but to reference something off another sheet, the formula is:

Code:
=Sheet1!a1
the Sheet1 section is the name of the sheet you want to reference from, the ! is a separator between sheet name and cell, and a1 is the cell you want referenced. You can get this in there by simply typing it into cell A1 in sheet 2, or you could click in the cell on sheet 2, press = and then click on the correct sheet (sheet 1), then the correct cell (a1) and hit enter. This works for numbers, text, anything in fact.
 

·
Superhuman Computer
Joined
·
1,632 Posts
No problem, glad to help!
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top