[BCAB] How to Copy Rows between work books in Excel

LU OGBE oluogbe at gmail.com
Sun Feb 23 23:21:51 GMT 2014


This should work for a range of rows:

1) Open both workbooks
2) Go to the workbook with the required data 
3) Select the columns to be copied by either:
a) Hold down Shift & use the cursor keys to highlight the required rows or
B) Press CTRL + G to bring up the 'Go to' dialogue box
Type the '1st cell ref':'last cell ref' e.g. to select the cells from
columns 'A' to 'G' on row 3, you will type 'a3:g3' & press 'Enter'
4)With the range of cells selected, press 'CTRL + C' to copy
5) Go to the 2nd work book
6) Place the focus in the location you want to paste the data from & press
'CTRL + V'



-----Original Message-----
From: Bcab [mailto:bcab-bounces at lists.bcab.org.uk] On Behalf Of Gerard
Sent: 23 February 2014 19:58
To: bcab at lists.bcab.org.uk
Subject: [BCAB] How to Copy Rows between work books in Excel

How can this be done?

To find out more about BCAB and the benefits that membership can bring,
please visit our website:

To manage your subscription to the BCAB mailing list, please visit our

To discuss matters relating to the mailing list, please email
moderator at bcab.org.uk.

More information about the Bcab mailing list