LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Copy / Append values of a named range from Workbook A Sheet1 to aclosed Workbook B Sheet1 in same folder

My range named X, only contains formulas
I need to copy / append values of this range to a closed destination workbook
in the same folder, which has the same number of columns and format as my named range.
Then, Save and Close the destination Workbook
and display message "Task Completed".
Thank you for your help.
J.P.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy from sheet1 and sheet2 and append to sheet3 in different format Ivan Hung Excel Programming 5 December 28th 09 12:35 AM
copying sheet1 from different workbooks contained in a folder to myone and only destination workbook. Jeff[_56_] Excel Programming 3 April 15th 09 07:24 PM
Copy from file1 sheet1/file2 sheet1 last blank row Tasha Excel Programming 2 August 22nd 07 08:24 PM
Copy or replace sheet1 from a closed workbook Steve Excel Programming 5 May 5th 06 12:01 AM
copy sheet1 from all open workbooks to one workbook Mike[_61_] Excel Programming 2 October 31st 03 02:16 PM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"