I hope someone can help me. I need the code on how to flatten SELECTED worksheets (not all) in my Excel file. I have more than 150 worksheets to flatten and the number of worksheets that need to be flattened will vary according to the data entered on the first worksheet. I do not know how to write codes yet and this file that I am using already has an existing code.
1) How do I write the code to flatten selected worksheets?
2) Where do I insert the code in the existing VBA script?
A similar question was asked and answered before but this question involved ALL worksheets. Here is the link to that question.
http://www.mrexcel.com/forum/excel-questions/519398-macro-flatten-worksheets.html
Thanks for your help.
1) How do I write the code to flatten selected worksheets?
2) Where do I insert the code in the existing VBA script?
A similar question was asked and answered before but this question involved ALL worksheets. Here is the link to that question.
http://www.mrexcel.com/forum/excel-questions/519398-macro-flatten-worksheets.html
Thanks for your help.