Major Help Needed! Newbie seeking help!

[Pumpkinjack]

Hey Folks:

Here is my problem. I have a PO/Project request template made. The template automatically numbers itself upon opening. After I save the completed PO/Project request as it's own .xls file, is there a way to have specific cells from this .xls file download/copy to a different closed ( or opened) worksheet?

Example, I have PO # 12345. Project started on 5/23/02 and needs to be finished by 6/5/02. The requestor of the PO is Jane Plain.

I save this info. Then, when I go to my tracking report worksheet in a different folder, I would have the PO#, Start Date, Finish Date contact name download automatically when I open the tracking report.

Does this sound like an impssible task? I am a newbie to the VB arena. In fact you could say I am a pure newborn to VBA.

I know you could just do the old cut and paste, but with the number of PO's and project coming my way, that would slow me down too much.

So if anyone can tell me if this could work and also how to do it, I would be eternally grateful!!!

Sincerely,
Pete

[PDuPre']

Just set up a simple macro that is saved to your Excel and not to the specific worksheet. Probably with a hot key CTRL-SHIFT-C or something that will automatically copy the data from the worksheet you are in to the worksheet you are using as a log file.
--------------------
You may be able to get by with a simple record macro. but, afterwards edit it and make sure it does not specifically name the workbook or worksheet you are in and it DOES specifically name the workbook you are using as a log file.

Hope this helps. Gotta run,

Philip

[lenze]

See the Help file for Template Wizard with Data Tracking or see this article from Microsoft.

http://support.microsoft.com/search/...;en-us;Q214246