ExcelBanter - Extracting data from one worksheet to another?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Extracting data from one worksheet to another? (https://www.excelbanter.com/excel-discussion-misc-queries/178802-extracting-data-one-worksheet-another.html)

onedub

Extracting data from one worksheet to another?

I have a worksheet compiled with data which is different everyday, this is a
basic worksheet with 8 coloums.

I basically want data from this worksheet extracted to 8 seperate worksheets
gouped by the heading of one of the columns.

What is the best way to get around this?

All times are GMT +1. The time now is 03:25 PM.