Dear Experts,
Good day, I need one help. I Trust this Forum definitely will solve this thread.
1. I need to create new workbook from userform with check box copy from multiple sheets from other XL file, the files includes pivot tables, graphs and values.
2. There are 4 teams , if I select Team 1 from combo box it should visible only Sheet1, Sheet2 & Sheet 3 like Team 2 and Team 3.
3. Finally if i select specific check boxes only and Click Generate report from command button that sheets should copy the same sheets with name and create a new XL file and save with Selected team name.
PFA sample copy of XL file. Kindly do the needful.
Thanks
Kumarpk
Bookmarks