valverde311
New Member
- Joined
- Apr 4, 2011
- Messages
- 4
Hi there,
I've read several examples where people refer to copying data from one worksheet to several different worksheets in the same workbook, then saving each worksheet as a new workbook.
What I'm trying to do: Create new workbooks containing two sheets from data in a separate workbook.
The first sheet in my master workbook has questions in column A and responses in column B. The second sheet has defined lists that are used for the drop-down choices in column B of the first sheet.
Additionally, I have a "data" workbook that has 100 columns that are each user's set of responses. What I'd like to do is create a macro that copies each column from the data workbook, pastes values into column B of the master workbook, then saves the workbook with the title of the user who it is for. Each of these "daughter" workbooks would contain two sheets, just like the master, because the second sheet contains the data validation for the responses.
Does anybody have any idea how I would do this?
I've read several examples where people refer to copying data from one worksheet to several different worksheets in the same workbook, then saving each worksheet as a new workbook.
What I'm trying to do: Create new workbooks containing two sheets from data in a separate workbook.
The first sheet in my master workbook has questions in column A and responses in column B. The second sheet has defined lists that are used for the drop-down choices in column B of the first sheet.
Additionally, I have a "data" workbook that has 100 columns that are each user's set of responses. What I'd like to do is create a macro that copies each column from the data workbook, pastes values into column B of the master workbook, then saves the workbook with the title of the user who it is for. Each of these "daughter" workbooks would contain two sheets, just like the master, because the second sheet contains the data validation for the responses.
Does anybody have any idea how I would do this?
