LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default gathering values from multiple workbooks

Help! My boss wants some stats. In order to get her what she needs, I will
have to open several hundred password protected workbooks (each workbook has
five pages), copy a column from worksheet 4, and paste the values to a new
workbook. I tried using Access to gather the data, but it just laughed at me.

Any suggestions on how to make the work go faster?

WinXP, Office 2003.

Thanks!
-----
 
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
Gathering rows of data from multiple wrkbks to single column SaipanRick Excel Worksheet Functions 2 June 15th 08 07:39 PM
gathering multiple spreadsheets into one Mark B Excel Worksheet Functions 2 May 7th 08 11:21 PM
Gathering data from multiple worksheets Andy F Excel Discussion (Misc queries) 1 February 1st 08 01:18 PM
Updating Workbooks from multiple links Workbooks TimJames Excel Worksheet Functions 1 December 15th 07 03:34 PM
adding certain cells in multiple worksheets in multiple workbooks Stephen via OfficeKB.com Excel Worksheet Functions 1 February 4th 05 08:31 PM


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

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"