hello,
im trying to create a macro that will take the worksheet out of the workbook, and copy it to a new workbook.
i have a workbook where i enter info into the first worksheet and then it is used to fillin redundant information on the next 7 or 8 worksheets. from there, i have to copy the worksheet to a new workbook and send it out.
can any one help me out with this?
also, is it possible to drag over more than one work sheet?
thanks,
christian
im trying to create a macro that will take the worksheet out of the workbook, and copy it to a new workbook.
i have a workbook where i enter info into the first worksheet and then it is used to fillin redundant information on the next 7 or 8 worksheets. from there, i have to copy the worksheet to a new workbook and send it out.
can any one help me out with this?
also, is it possible to drag over more than one work sheet?
thanks,
christian