COMBINE/CONSOLIDATE ALL SHEETS INTO ONE except SUMMARY and DATA

[choleb]

Hi All,

I have a one workbook with multiple sheets. And I wanted to combine these sheets into one sheet except for worksheets with sheet name "summary" and "data".

My code is not working because it is still combining all the sheets even if the worksheets "summary" and "data" are hidden.

Can anyone please help me?

Thank you in advance for your help.

 

[sdsurzh]

please include the below code in between your code then it will work

For i = 1 To Worksheets.Count
If Worksheets(i).Name <> "Summary" And Worksheets(i).Name <> "Data" Then


'' your code should come (either copy, paste, selecting sheet whatever it may be)
End If
Next

 

[healey21]

Welcome to the forum, can you show your code you are using this will help provide a solution for you.

 

[choleb]

@sdsurzh Thank you so much for your response. Finally I have resolved my issue.

@healey21 Thank you for a warm welcome.