Microsoft Excel - Macro to split worksheet data to multiple worksheet with headers

Asked By sudhakar srivatsav on 03-Jan-13 01:25 AM
Hi,
I need Macro to split existing master sheet to multiple worksheets it can based on column criteria or general one line space in between the data to split.

thanks
Stephen P replied to sudhakar srivatsav on 03-Jan-13 08:48 PM
I would say put loops in to select the cells and cut copy and paste them to another sheet. If you would be so kind as to show an example of the "Master sheet" so I can work with it.