below code merges all of the worksheets of the currently active Workbook into a master worksheet named 'Combined'.
Could somebody help me tweak this code with the following requirements.
All of the worksheets to be copied into the 'combined worksheets' have a column header that spans three rows (therefore the '.Offset(3, 0)' in line 15). The Combined Sheet should have this column header at the very top, i.e a column header that spans three rows. With the current code it is just a one row column header.
All of the sheets are to be combined in this master worksheet named 'Combined' with the exception of sheets named 'Evaluation', 'Evaluation Master' and 'Result'
The selected rows/cells in all of the sheets are to be deselected.
Help is much appreciated. Thank you very much in advance.
'Merging multiple worksheets into a master worksheet
Dim J As Integer
On Error Resume Next
Sheets(1).Name = "Combined"
For J = 2 To Sheets.Count
Selection.Offset(3, 0).Resize(Selection.Rows.Count - 1).Select