ByteMarks,
Many thanks for prompt suggestion, but unfortunately adding the dot hasn't solved the problem.
TMS,
Apologies, hadn't noticed the Workbook had not attached (Hazard of working all hours!). It is now.
"Should be" worksheet shows what the output should be, enabling the PIVOT Table and SLICERS in Cols U - AB.
Objective is to loop through each Monthly worksheet, sort the data by the first revenue stream (Col K) and post the details of that bloc, putting the revenue in Col L of the MASTER worksheet, adding the Revenue stream Name in Col K, then repeat sorting by Col L (Copies to next free row of MASTER), then Col N. Result is all three Streams are listed sequentially in one column.
Problem is the Code generates an Error when I define the Range to copy across.
As before, all solutions, suggestion and alternatives welcome as ever.
Ochimus
Bookmarks