Generate list from other files
Thank You Dave,
That does exactly what I want. However, it does somethings I don't want
as well:
1) I forgot about the fact that all of the workbooks that I open have
links in them that I need to keep, and for every workbook that gets
opened a dialog box asks me if I want to update them and I do want to
update them (well, actually it doesn't matter for my purposes).
2) I also forgot that they all have a userForm that automattically pops
up when each one is opened, and then I have to manually close each one.
How do I modify that code so that I don't have 80 different windows
bugging me each time I run it?
I have another question. When I explained my situation, I simplified
for clarity. I really need to reference cells J5 through J82, L5
through L82, and M5 through M82 and place them correspondingly in the
constant worksheet in H4:H81, I4:81, and J4:81. I tried adapting the
code for my purposes with no luck. What is the best way to do that?
Thanks,
Joe
|