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

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


Hi,

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'

 

HTH. 

Regards,
LU
-----Original Message-----
From: Bcab [mailto:bcab-bounces at lists.bcab.org.uk] On Behalf Of Gerard
Sadlier
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?
Thanks

-- 
To find out more about BCAB and the benefits that membership can bring,
please visit our website:
http://www.bcab.org.uk/

To manage your subscription to the BCAB mailing list, please visit our
website:
http://www.bcab.org.uk/bcab-discussion-list/

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





More information about the Bcab mailing list