How to import cels from another workbook

  • Thread starter Thread starter Ruud
  • Start date Start date
R

Ruud

Hallo,

In my workbook "Contacts.xls" I want to import cells from "Sales.xls"
I work with macro's, but can't find the formula.

Hope someone can give me an text example
Thanks
Ruud
 
Ruud,

I think you need to provide a few more details about what
specifically you want to do.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



Hallo,

In my workbook "Contacts.xls" I want to import cells from
"Sales.xls"
I work with macro's, but can't find the formula.

Hope someone can give me an text example
Thanks
Ruud
 
When I open my Workbook-A, automatically a macro starts.

Now I also want that the cells A2:BN400 in Workbook-A. are
replaced by A2:BN400 from Workbook-B.
(if possible, not by opening Workbook-B)
thanks
Ruud
 
Back
Top