Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 04, 10:33 PM
Trevor
 
Posts: n/a
Default How do I extract cells from multiple workbooks

I am trying to extract the same cells references from multiple workbooks. All
the wokrbooks are identical apart from the information stored. I want to be
able extraxt all this data and store in another workbook. I have managed to
do this but it would take me along time as I would have to manually update
the filename of the work books one by one. the filesnames are DOP WK01-02,
DOP WK03-04 etc. How do I tell it to increase the numbers by one. Any ideas
would be much appreciated.
Thanks

Trev

  #2   Report Post  
Old November 25th 04, 11:59 PM
Ron de Bruin
 
Posts: n/a
Default

Try this Trevor
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Trevor" wrote in message ...
I am trying to extract the same cells references from multiple workbooks. All
the wokrbooks are identical apart from the information stored. I want to be
able extraxt all this data and store in another workbook. I have managed to
do this but it would take me along time as I would have to manually update
the filename of the work books one by one. the filesnames are DOP WK01-02,
DOP WK03-04 etc. How do I tell it to increase the numbers by one. Any ideas
would be much appreciated.
Thanks

Trev





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
Multiple X-Axis Values Rob Herrmann Charts and Charting in Excel 2 January 23rd 05 11:57 PM
Trendlines to ignore empty cells Hoochi Coochi Man Charts and Charting in Excel 7 January 14th 05 02:31 PM
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 3 December 31st 04 11:31 AM
To get a lot of charts that refer to different cells Anderson Lee Charts and Charting in Excel 1 December 28th 04 03:35 PM
Excel Charts and cells sacha Charts and Charting in Excel 1 November 30th 04 03:30 PM


All times are GMT +1. The time now is 03:31 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017