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: 6
Default Pasting from a specific Workbook to another workbook without having to name it.

Pleeeeeeeease Help...

It's a Saturday night, and I have the pleasure of being at work cause
of a serious deadline on Monday morn..

I have 200+ templates (all with different names) that need to have an
amendment made to them. The macro I have created to make all of the
amendments is saved within personal.xls.

I am stuck on one thing: There is a list of values used for validation
lookups contained within each template and they need to be replaced
(management have changed them!!). To make it even more interesting, in
several of these workbooks the values are different. However, the aim
is to update these values and make them all uniform.

I have typed the new values into a separate work book, as I though the
simplest way would just be to copy and paste the whole range from this
workbook (New Lists.xls) to the template.

Problem:
Issue is that with 200+ templates, I don't want to have to name the
workbook the values are to be pasted in to.
 
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
Pasting from workbook to workbook Trapshooter Excel Discussion (Misc queries) 0 June 16th 09 07:58 PM
Taking specific rows from on workbook to create another workbook Michelle Excel Worksheet Functions 1 May 12th 07 04:54 AM
Copy Data from Workbook into specific Worksheet in other Workbook? kingdt Excel Discussion (Misc queries) 1 March 16th 06 06:55 PM
pasting from one excel workbook to another KB Excel Worksheet Functions 1 May 17th 05 08:00 PM
pasting selection to end of workbook? joshashcraft Excel Programming 1 August 27th 03 11:09 PM


All times are GMT +1. The time now is 10:53 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"