Excel '02 Workbook to workbook link...HELP!

[shutterlug]

Hello Everyone,

I'm in the middle of what has turned into a very strange project. I am desperate and could use some help.

Here are the circumstances:

- The company I'm working for uses Excel '02.
- I was initially asked to do this as an Access DB, but...
- Data comes from a web-based report generator into an Excel workbook, so why go with Access, especially when no one in the office knows how to use it...
- Generated workbook has a different page for each location (first two pages of workbook is unnecessary)
- Only some of the information from each page of the workbook needs to be put into a different workbook in a format that has been predetermined.
- The end workbook is to be given to a client as a monthly update and so the lions' share of the transfer should be, if possible, automated.

I am NOT a programmer, but I've been desperately trying to learn how to be one. I know that there should be a fairly easy way to do this (how hard can drawing information from one spreadsheet to another be???), but so far I've just been banging my head against a wall.

I'm assuming this is best done with a Macro/VBA, and I've already conceptually gotten that I'll need to use a nested loop to take out duplicate information when the new reports will be run.

I've been considering turning the end workbook into a template and hoping that will make things easier, moving the data into the pre-determined format.

Can someone help me??? I've bought 4 different books and read about 1500 pages on Excel (which will help me in the long run, I'm sure) and I'm just going nuts. Thank you so much!!!!

Josh

[Killer42]

Hi there.

I only have a moment, but I can make a couple of suggestions.

• It will probably help things along (for you and us) if you try to write out, in as much detail as possible, the complete process which needs to happen. In essence, that's what programming is about. You work out the process to be performed, and break it down into simpler and simpler steps until a dumb computer can follow them. (That's my own opinion, of course - you're likely to see some cross-discussion on this point. :))
• The quick and simple method to work out the code to do any particular process in Excel is to tell Excel to record a macro, then do the process yourself. Then you can look at the generated macro to see how to code it. This is a very convenient way to pick up VBA, too.