If i write something in A5 in sheeet3 and I want dat it should show in b3 in Sheet1...what would b the formula ???please help
John
Need help about formula
Started by
blrjohn07
, Feb 11 2008 06:37 AM
#1
Posted 11 February 2008 - 06:37 AM
blrjohn07
-
- Member
-
- 55 posts
Member
If i write something in A5 in sheeet3 and I want dat it should show in b3 in Sheet1...what would b the formula ???please help
John
#2
Posted 11 February 2008 - 09:08 AM
Ax238
-
- Technician
-
- 1,323 posts
Tech Staff
Hello John,
The formula in Sheet1 B3 would be as follows:
Regards,
Ax
The formula in Sheet1 B3 would be as follows:
=Sheet3!A5You can get this formula automatically by putting an = in Sheet1 B3 to enter formula mode, clicking on Sheet3, clicking the cell (A5), and pressing Enter.
Regards,
Ax
#3
Posted 12 February 2008 - 12:26 AM
blrjohn07
- Topic Starter
-
- Member
-
- 55 posts
Member
wow! Its prety simple...and what i want that is done..many thanks AX...I love geekstogo
#4
Posted 12 February 2008 - 08:11 AM
Ax238
-
- Technician
-
- 1,323 posts
Tech Staff
No problem at all, glad I was able to help you.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:
Sign In
Create Account
