Copy multiple cells to workbooks faster?

Closed
sunshine - Oct 12, 2010 at 01:52 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Oct 15, 2010 at 12:48 PM
Hello,

I am trying to copy values from different worksheets and workbooks into a new worksheet. I know how to do this but it is very time consuming to type "=" then go click on each individual cell I want to copy over. Is there a way I can copy multiple values from other workbooks or worksheets at once (while maintaining their formula)? Help would be greatly appreciated! Thanks!



1 reply

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Oct 15, 2010 at 12:48 PM
are the sheets / workbooks identical in layout etc.
0