ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2 Books, importing information Excel (https://www.excelbanter.com/excel-discussion-misc-queries/65834-2-books-importing-information-excel.html)

Hopeless

2 Books, importing information Excel
 
How do I import data from one excel book to another? One book has much data
which I want to import some of, to another book. This would constitute
adding a couple of rows off of one book, then entering the total into another
book where that information is needed. I can't seem to be able to find this
info in the help menu, or, I am looking in the wrong place.

Gary L Brown

2 Books, importing information Excel
 
Highlight the rows in the workbook with the data.
Copy the rows...
EditCopy
Go to the new workbook.
Select the first cell of the area in the worksheet where you want the data
to be copied to and...
EditPaste

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Hopeless" wrote:

How do I import data from one excel book to another? One book has much data
which I want to import some of, to another book. This would constitute
adding a couple of rows off of one book, then entering the total into another
book where that information is needed. I can't seem to be able to find this
info in the help menu, or, I am looking in the wrong place.



All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com