Copying Data Pulled from a Listbox to a New Sheet

I have a spreadsheet that contains a lot of data in Sheet1, and I have a userform with two listboxes. the first listbox pulls in the column headings from Sheet1. the user can then choose which info to do something with, and move them to the second listbox. When the user clicks the ok button, I am creating a new worksheet and trying to match the column headings from the second listbox with their corresponding data and put the columns of data, including heading, in the new worksheet. Here is the code I have so far:

Please Login or Register  to view this content.

Can anyone help me with how I would go about actually getting the data to the new worksheet, "Dig_Plot_Work"? is my code that far off? I was thinking I may have everything except for the code that goes after Set rngDigData. I already have the code to plot the info once I get the data to the new worksheet. Thanks in advance for your help!

Here is the sample spreadsheet I'm working with in case it helps...

protonLeah,
thanks for the post. everything worked except that the cycles values in column A of sheet 1 didn't make it to the new sheet. that's ok, though. I got it figured out. Thanks for your help!