| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying data from one book to another
I want to import some info from book2 into book1, I thought it could be done
by having both files open at the same time and running a macro form book1. The information to copy/import is in cells or ranges of cells. For example, cell D12 (sheet1) in book2 needs to go into cell C4 (sheet1) in book1. There are about 150 values to be copied/imported all together. That's about as far as I have got and any help would be gratefully received. Gareth |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping Workbook Name Out of Sheet When Copying to Different Book | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Copying multiple sheets to a new book and undertake specialised ed | Excel Discussion (Misc queries) | |||
| Copying Worksheets from one book to another | Excel Programming | |||
| macro stops copying sheets into a book after the 11th sheet | Excel Programming | |||
![Gareth[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
