Exporting a table to a new file and creating a wizard

%3CLINGO-SUB%20id%3D%22lingo-sub-1879747%22%20slang%3D%22en-US%22%3EExporting%20a%20table%20to%20a%20new%20file%20and%20creating%20a%20wizard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1879747%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20very%20complex%20data%20workbook%2C%20and%20I%20would%20like%20to%20have%20a%20button%20that%20exports%20data%20from%20a%20table.%20Then%20creates%20a%20sheet%20with%20the%20export%20date%20and%20a%20few%20other%20fields%20filled%20by%20the%20user.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20wizard%20where%20the%20user%20clicks%20on%20a%20button%20and%20a%20dialog%20box%20opens%20where%20the%20user%20can%20select%20the%20date%2C%20fill%20in%20other%20data%2C%20etc.%20Then%20a%20new%20file%20is%20created%20with%20one%20sheet%20containing%20the%20data%20table%20and%20another%20sheet%20containing%20the%20user-filled%20information%20including%20the%20date%20information.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%20how%20I%20can%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1879747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1881130%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20a%20table%20to%20a%20new%20file%20and%20creating%20a%20wizard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881130%22%20slang%3D%22en-US%22%3EThings%20like%20this%20can%20be%20done%20with%20VBA%20UserForms.%20If%20you%20don't%20have%20any%20experience%20with%20it%2C%20you%20might%20spend%20some%20time%20learning%20it.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all,

 

I have a very complex data workbook, and I would like to have a button that exports data from a table. Then creates a sheet with the export date and a few other fields filled by the user. 

 

I would like to create a wizard where the user clicks on a button and a dialog box opens where the user can select the date, fill in other data, etc. Then a new file is created with one sheet containing the data table and another sheet containing the user-filled information including the date information. 

 

Please advise how I can do that?

1 Reply
Highlighted
Things like this can be done with VBA UserForms. If you don't have any experience with it, you might spend some time learning it.