VBA Copy and Paste with an Input Page to specify copy ranges to new table

Hi, I'm working on a project where we are using survey monkey and the export from it is all the answers from a survey are in a single row (one row for each survey).

What I want to be able to do is have an input page where the user manually specifies the columns to paste over to a new sheet, for each section of the survey. So for example for general information this is stored in columns A through H. So the user would specify a start column of A in a cell and an end column of H. The macro would then go to the data dump sheet grab the data between columns A and H for all of the surveys and paste it into another sheet where it can be formatted.

I'm thinking for this simple example there are three sheets: Input, DataDump, and GeneralInformation. The input sheet specifies the column copy range, like B2 is the start column (value of "A") and B3 is the end column (Value of "H") on the DataDump and pastes into the GeneralInformation page on cell "B10" lets say.

Example1.xlsx

Thanks!

See if this is how you wanted,

Please Login or Register  to view this content.