Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
halem2
 
Posts: n/a
Default Copy worksheet ranges from One Workbook to another from


Hi:

I have a workbook with about 250 worksheets, let's call it MW.xls. All
worksheets have a name(a1, a2, etc). Once a week I copy groups of
worksheets and save them as different workbooks(let's say wb1.xls,
wb2.xls). Those workbooks get updated and emailed back to me. I receive
about 15 workbooks through email.

I need to copy different cell ranges from the updates workbooks'
worksheets (let's say from wb1.xls) to the original one(MW.xls). So if
in the emailed workbook I have worksheets a1, a2, a3, I need to copy
cell ranges b5:k5 and a7: j10 to the same worksheets in the original
workbook(MW.xls).

It is a very tedious process and it is identical for every sheet.

Thank you in advance for any help,


--
halem2
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=526073

Reply
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
quick copy worksheet into other sheets in same workbook Mick M New Users to Excel 2 December 20th 05 10:49 PM
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 10:02 PM
copy page setup from worksheet to another within workbook Fanny Excel Worksheet Functions 2 October 6th 05 02:49 AM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
Help - now really stuck! File transfer problem ohboy! Excel Discussion (Misc queries) 10 May 2nd 05 09:07 PM


All times are GMT +1. The time now is 08:07 AM.

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

About Us

"It's about Microsoft Excel"