Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel sheet question

Status
Not open for further replies.
Mag0007

Mag0007

MIS
Feb 15, 2005
829
US
Hi,
I have an excel document with 5 tabs. (Tab A, Tab B, C, D,E)

I would like to use the data from Tab (A1:A3) into Tab B. So when I change data in A1, it should also reflect in Tab B.

Any advice?

TIA
 
Sort by date Sort by votes
on Tab B cell A1 put:

='Tab B'!A1



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
err, I meant ='Tab A!A1 if you want sheet Tab B cell A1 to reflect sheet Tab A cell A1

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
961
bs6600
bs6600
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
713
Bijugate
Bijugate
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
570
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
509
SkipVought
S
Avayacoolstuff
  • Locked
  • Question
MS quick query question
Replies
1
Views
323
PatrickRoggers
PatrickRoggers

Part and Inventory Search

Sponsor

Back
Top