LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
Posts: 8
Default dynamic reference to data in multiple closed workbooks

Hi, I'm working with a job list (generated out of a different program) and
data in associated closed workbooks. For example, the job list has names like
HD-100311-TA031110, SHT-100312, 032110Mag and I can generate a list of these
jobs along with other information I need. For every job there's an associated
workbook and, without opening the workbook I want to pull, for example,
'[\\de-mt1\clients\QC Reports\Proofs Adjusted\HD-100311-TA031110 proof
adjusted.xls]'Upload'!A$2 where the only information that will change is the
job name. I'm novice enough not to know how to do this even if the workbook
is open using the INDIRECT function.

My current workbook has two tabs, one where I paste the job list and other
details straight from my export. The second tab then references the first
tab, then I want to pull data from the closed workbooks. (I have to make sure
things like the listing counts match, for example.) The bulk of what I need
to do is get data from these closed workbooks. The number of jobs is very
dynamic and will probably be at least 50 most of the time.

In reading postings I found references to Harlan Grove's PULL function a
supposedly faster one from Wilson So called IndirectEx but both are way over
my head. Figuring this out will save tons of manual effort every week so it's
worth me trying to figure it out. Can you help?
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 Data from Multiple Closed Workbooks to Open Workbook Kris Excel Programming 3 October 31st 06 08:36 PM
Importing data from multiple closed workbooks Judy[_7_] Excel Programming 5 December 29th 05 10:46 PM
Run Macro On Multiple Closed Workbooks Andy Excel Programming 1 December 1st 05 04:47 PM
Dynamic VLOOKUP from external, closed workbooks dolik[_2_] Excel Programming 0 June 13th 05 01:44 PM
copy dynamic ranges in multiple workbooks based on a data in 1 col jbsand1001 Excel Programming 0 May 18th 05 07:08 PM

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