I wonder whether the following task can be performed by running a macro:
The macro is to loop through data records.
Whenever it hits an entry in Column C formatted Verdana 16, the macro is to copy that row along with subsequent rows until the macro hits another entry in Column C (formatted With Verdana 16) and paste these rows into its own worksheet. The macro is to loop until the last entry in Column C has been found (formatted with Verdana 16pt).
I have attached a sample file with a couple of examples and instructions/explanations.
Help is much appreciated.Thank you very much in advance.