Kim Wrote:
I am trying to list from 100s of sheets a number so I go to lets say F10
on
sheet 2 (sheet2!f10), (sheet3!f10), (sheet4!f10). How can I drag and
copy so
sheets change?
You can group the sheets together, click on the first sheet tab, then
click on the last sheet tab, this should group them all together, so
now whatever you do to sheet 1 will take effect to all the sheets,
right click on any of the tabs to ungroup, I have no idea if this works
for hundreds of sheets but it is worth a try


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520846