Thread: [Solved] Repeated Cells in different sheets
View Single Post
 
Old 04-24-2011, 03:33 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi mhdagtas,

You could use a 3-d formula. See "Create a 3-D reference to the same cell range on multiple worksheets" in Excel's Help file.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote