Copy multiple cells to workbooks faster? [Closed]

Report
-
Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
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

Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
243
are the sheets / workbooks identical in layout etc.