Is there a way to create a Wizard type of program to auto populat.

[Guest]

I am trying to create a Wizard type program that auto-populates a separate
spreadsheet in Excel. Basically, I would like to have a program that asks a
series of questions and then takes the answers and imports them into a
spreadsheet in specifically designated cells. Any ideas? Do you use Macro
or Add-in tools or something different?

 

[John Mansfield]

Hi,

John Walkenbach describes in detail how you can build
wizard type programs in his Excel 2003 VBA Programming
book. John also has versions 2000 and 2002 available.
Sorry, I can't remember the exact titles but they are
something similar to the above.

John Mansfield
pdbook.com